Search Results

Search found 24890 results on 996 pages for 'pivot table'.

Page 200/996 | < Previous Page | 196 197 198 199 200 201 202 203 204 205 206 207  | Next Page >

• How to recover data from a table, and store that into list?

  - by Wilhelm

  How can I get ALL the data from a table of my DB (mySQL) using hibernate, and store the output into List of Objects? I'll use this List, to populate a JTable.

  Read the article

• Postgresql: how to create table only if it does not already exist?

  - by Fredriku73

  I am totally new to postgresql. How can I do a condition to create a table only if it does not already exists? Code example appreciated.

  Read the article

• Put indexes on a table with lots of BOOL/TINYINT?

  - by John Tyler

  An old mentor once told me to place indexes on most things you use a WHERE clause for. Should I put an index on BOOL/TINYINT's? There is a significant amount of them in the table I am working with, and often results are filtered by anywhere from 1-20 of these boolean conditions.

  Read the article

• Is there a way to get photo tags and new friendship type events by querying the FQL stream table?

  - by Fletcher Moore

  When you look at your stream on the Facebook website, events such as "FriendX was tagged in an album", "FriendY is attending EventZ", and "FriendK and FriendL are now friends". I've tried various "vague" queries on the stream table, and so far I have been unable to get these types of events. Is this possible, or do I need to query the all of the other tables and write a ton of logic to try to figure out which new events to show and how to show them?

  Read the article

• convert table of input values into 2D array or struct?

  - by Henry

  What's the easiest way to convert a table of values (2D grid like Excel), into a 2D array or struct in ColdFusion? Thought of using dot in the name and eval them to become struct, but AFAIK name attribute of input field can only contains alpha numeric and underscore, and first char must be an alpha char.

  Read the article

• Fluent Nhibernate napping to existing database with primary key in joining table of a many to many r

  - by Todd

  I have an existing database with a many to many relationship however the joining table has a primary key ID and 2 foreign keys to do the join. Is it possible to configure the mapping files to handle this? at the moment i am stuck. Thanks

  Read the article

• Should searchable date fields in a database table always be indexed?

  - by Spencer Ruport

  If I have a field in a table of some date type and I know that I will always be searching it using comparisons like between, > or < and never = could there be a good reason not to add an index for it?

  Read the article

• .NET: Which strategy is better for populating a gridview? using a Data Table and bind it or using a

  - by odiseh

  hi ASP.NET: Which strategy is better for populating a gridview? filling a Data Table and bind it or using a data reader ? Which one has a better performance?

  Read the article

• How to use hook alter form in module to register a user and also save some data in another table?

  - by user363036

  have a general idea on how to use hook alter to modify the feel of the registration form . However the challenge I have is to not only have the user register, but to save some extra data into another table and then redirect user to a new page. How would I get about doing that? Please help

  Read the article

• Simple way to render tuples to a table in ASP.NET 2.0?

  - by njk

  Say I have a data structure like a Dictionary<string, Dictionary<string, int>> or similar, and I want to render this as an HTML table with row-headers as the first string key, and column headers as the second string key. Is there a built-in or other Control for this?

  Read the article

• What is the best way to determine if table already has record with specific ID?

  - by iburlakov

  Hello. I have a short question. Im my current project I'm using LINQ-to-SQl. That is the best way to determine if table has record with specific ID? Thanks in advance.

  Read the article

• JPA Is there a way to do something like SELECT <field>, count(*) FROM <table> GROUP BY <field>

  - by javydreamercsw

  I've been looking in the web for examples on the aggregates like count but it seems all of them are using the aggregate alone. SELECT field, count(*) FROM table GROUP BY field Should have something like: field.value1, x1 field.value2, x2 .... I'm looking for a pure JPA answer for this one. If not I guess I can then do further queries just for the count part but that seems unefficient. Any ideas?

  Read the article

• Mysql Joins - How to know which row is retrieved from which table...?

  - by SpikETidE

  Hi everyone... Consider i am using join on three tables to get a desired result-set... Now in that result set, is there anyway that i can find out which row comes from which table...?

  Read the article

• How can I LIMIT rows updates in MySQL if more than one table is involved?

  - by Taz

  I am trying to run an UPDATE query UPDATE ner.nerdataset, ner.shortabstracts SET ner.nerdataset.ShortAbstract=ner.shortabstracts.ShortAbstract WHERE ner.shortabstracts.Resource=ner.nerdataset.ResourceURI LIMIT 10; As MySQL does not allow the use of LIMIT when more than one table is involved in UPDATE what else can be done to limit this?

  Read the article

• Is it possible to use CSS to align these divs/spans in a table-like manner?

  - by Justin L.

  I have <div class='line'> <div class='chord_line'> <span class='chord_block'></span> <span class='chord_block'>E</span> <span class='chord_block'>B</span> <span class='chord_block'>C#m</span> <span class='chord_block'>A</span> </div> <div class='lyric_line'> <span class='lyric_block'></span> <span class='lyric_block'>Just a</span> <span class='lyric_block'>small-town girl</span> <span class='lyric_block'>living in a</span> <span class='lyric_block'>lonely world</span> </div> </div> (Excuse me for not being too familiar with proper css conventions for when to use div/spans) I want to be able to display them so that each chord_block span and lyric_block span is aligned vertically, as if they were left-aligned and on the same row of a table. For example: E B C#m A Just a small-town girl living in a lonely world (There will often be cases where an empty chord block is matched up to non-empty lyric block, and vice-versa.) I'm completely new to using CSS to align things, and have had no real understanding/experience of CSS aside from changing background colors and link styles. Is this possible in CSS? If not, how could the div/class nesting structure be revised to make this possible? I could change the spans to divs if necessary. Some things I cannot use: I can't change the structure to group things by a chord_and_lyric_block div (and have their width stretch to the length of the lyric, and stack them horizontally), because I couldn't really copy/select the lyrical lines continuously in their entirety, which is extremely critical. I'm trying to avoid a table-like solution, because this data is not tabular at all. The chord line and the lyric line are meant to be read as one continuous line, not a set of cells. Also, apart from the design philosophy reasons, I think it might have the same problems as the previous thing bullet point. If this is possible, what div/span attributes should I be using? Can you provide sample css? If this is not possible, can it be done with javascript?

  Read the article

• How can I tell when a MySQL table was last updated?

  - by RaGE

  In the footer of my page, I would like to add something like "last updated the xx/xx/200x"; with this date being the last time a certain mySQL table has been updated. What is the best way to do that ? Is there a function to retrieve the date ? Should I make an access to the database everytime my footer is displayed ?

  Read the article

• Quickest way to dump Python dictionary (dict) object to a MySQL table?

  - by NJTechGuy

  I have a dict object. I dumped the data using this: for alldata in data: # print all data to screen print data[alldata] Each field had brackets [] and 'None' values for NULLS and date.datetime for date values. How do I dump this dict to MySQL table? Thank you!

  Read the article

• I have a 18MB MySQL table backup. How can I restore such a large SQL file?

  - by Henryz

  I use a Wordpress plugin called 'Shopp'. It stores product images in the database rather than the filesystem as standard, I didn't think anything of this until now. I have to move server, and so I made a backup, but restoring the backup is proving a horrible task. I need to restore one table called wp_shopp_assets which is 18MB. Any advice is hugely appreciated. Thanks, Henry.

  Read the article

• Append Results from two queries and output as a single table.

  - by tHeSiD

  I have two queries that I have to run, I cannon join them But their resultant tables have the same structrure. For example I have select * from products where producttype=magazine select * from products where producttype = book I have to combine the result of these two queries, and then output it as one single result. I have to do this inside a stored procedure. PS These are just examples I provided, i have a complex table structure. The main thing is I cannot join them.

  Read the article

• New to CakePHP -> How To Add Columns To a MySQL Table?

  - by walden

  I had a website made for me a long time ago, and the programmer did it in CakePHP. I'm now editing his scripts. I added a couple columns to a table, and found that doing saveField() on the new column does not do anything. How do I make CakePHP recognize the new columns? I'd appreciate your help. I'm not too familiar with CakePHP, so please go easy on me =)

  Read the article

• Hi can anyone try how to solve the query for this table structure???

  - by atrueguy

  Employee table structure first_name varchar2(100) last_name varchar2(100) hire_date date show all the employee who hired on the day of the week on which highest number of employees were hired?

  Read the article

• move entry up/down in a table using phpmyadmin?

  - by ajsie

  is there a way to move an existing entry up/down in a table? i cant see any button for it in phpmyadmin.

  Read the article

• Does unique on a temporary table column create an index?

  - by Bmw

  I have a temporary table that I'm using and I have a unique column, example:myID INT UNIQUE Would this create an index on that column? Or do I have to explicitly create the index?

  Read the article

• In MySQL, if the movies table has a description field, how to do search on this description?

  - by Jian Lin

  Say, using MySQL, if the movies table has 20,000 records, and each record has a field that is the description of the movie, up to 2k byte long. How can we search for movies with the word "nature" in its description? If possible, it is to be fast, instead of going through all the 20,000 records. (if in some other situations, like for books, where n can be 200,000 or more).

  Read the article

• Is there any Inheritance problem with <table> also like form elements?

  - by metal-gear-solid

  Is there any Inheritance problem with <table>, tr th td tbody thead tfoot also like form elements? In IE 6+ and FF 3+ with Strict doctype.

  Read the article

< Previous Page | 196 197 198 199 200 201 202 203 204 205 206 207  | Next Page >