Search Results

Search found 31606 results on 1265 pages for 'generate table'.

Page 241/1265 | < Previous Page | 237 238 239 240 241 242 243 244 245 246 247 248  | Next Page >

• How do map 1-to-1 relationship in grails to just 1 table under the covers?

  - by egervari

  Let's say I have a UserAccount domain class that has a UserPreferences domain class. I do this to separate the fields for organization purposes. Is there a way to tell grails/gorm that I really want it to map these domain classes to just the user_account table under the covers? Thanks!

  Read the article

• How to bind DataGrid to display only 25 records of a table having more than 1000 records ..??

  - by Devashri

  I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance..??

  Read the article

• Cocoa: how to nest a button inside a Table View cell?

  - by underthetable

  Take a look at the top pane of the Xcode window. There's a table list, with checkboxes in one of the columns. That's the interface I want to do. So how do you nest a button in an NSTableView cell?

  Read the article

• how to insert an integer value from a Grid to Sql table?

  - by z-chaos

  Hi, I have a AdvWebGrid where the 7th coloumn is DynEdit where user will enter the value.Now I have to take the enetered value and insert into the Sql tablel. For example i have 7 records in the grid the user will enter some comments for the first three record and save.Now i have to insert/update the first three comments in the table.

  Read the article

• how to run Make table query that i have in access in C# code ?

  - by Gold

  hi i have query (DO2) in access that makes a table and inserting any data. how to run this query in C# code ? i try this: SQL = "Select * from DO2"; Cmd = new OleDbCommand(SQL, Conn); Cmd.ExecuteNonQuery(); Cmd.Dispose(); but i get error

  Read the article

• How to SUM() from an offset through the end of the table?

  - by keithjgrant

  If SELECT SUM(amount) FROM transactions ORDER BY order LIMIT 0, 50 sums the amount field for the first 50 records in a table, how do a sum all records after the first 50? In other words, I'd like to do something like SELECT SUM(amount) from transactions ORDER BY order LIMIT 50, *, but that doesn't work.

  Read the article

• MySQL Sub-query.. Doesn't provide proper information after 3 entries into table.

  - by Chris Keefer

  After I get 3 rows in my forum_threads table this no longer does it's job; to organize a list of active forum threads and put the most recently responded-to thread at the top of the list, followed by second most recent posted-to thread, followed by third, fourth, etc. Like I said, the query works wonders up until there is a fourth row added to forum_threads. SELECT forum_threads.*, forum_posts.thread_id FROM forum_threads INNER JOIN (SELECT MAX(id) AS id, thread_id as thread_id FROM forum_posts group by thread_id order by id DESC) forum_posts ON forum_threads.id = forum_posts.thread_id

  Read the article

• Zend Framework: How to subtract amount from database table field ?

  - by NAVEED

  I want to subtract a amount from a table's field in Zend Framework. I can run it with SQL using following query: UPDATE `Person` SET credit=credit-50 where id=1 But how to write above SQL query in Zend Framework?

  Read the article

• C# SQL: What is the best way to implement a dynamic table?

  - by SirMoreno

  I want to allow the user to add columns to a table in the UI. The UI: Columns Name:__ Columns Type: Number/String/Date My Question is how to build the SQL tables and C# objects so the implementation will be efficient and scalable. My thought is to build two SQL tables: TBL 1 - ColumnsDefinition: ColId, ColName, ColType[Text] TBL 2 - ColumnsValues: RowId, ColId, Value [Text] I want the solution to be efficient in DB space, and I want to allow the user to sort the dynamic columns. I work on .NET 3.5 MSSQL 2008. Thanks.

  Read the article

• How to use PHP Load Data Infile to replace the current copy of the table with the new one?

  - by NJTechGuy

  We get a new copy of data in a pipe-delimited text file from time to time. I have to refresh the table or in other words, replace the existing copy with that of the newly generated copy (output.txt). Any ideas are highly appreciated. Thank you..

  Read the article

• What is the cleanest way to sort "describe table" query results ?

  - by Youssef AZARI

  Hello everyone, I'm working on "describe table" output to show a list of fields and their types, i want my primary keys to be at top of the list.. I think there's no way to sort describe's results using SQL (something like 'order by') rather than sorting it in PHP. what do you think guys ? thanks

  Read the article

• How to dump temporary MySQL table into a file?

  - by Alex N.

  Is there a way to create a dump/export/save a temporary MySQL table into a file on disk(.sql file that is, similar to one that is created by mysqldump)?

  Read the article

• How do I make a table from a List MVC?

  - by user54197

  I have a List(Name, Item, Group#) that I would like to display in a table. How do I display this data with all the names in the 1st row, item in the 2nd, and group number in the 3rd row. Name: | Jon | Tom | Kate | Brian | Item: | Cup | Hat | Door | Store | Group#:| 2 | 8 | 10 | 154 |

  Read the article

• SQL Server: Is it possible to get procedure or table creation and last alter date?

  - by Woland

  SQL Server: is it possible to get procedure or table creation and last alter date? If it is then how do to it? SQL Server 2005

  Read the article

• Need a good way to store data in a DB from a table on a webpage that can have N columns.

  - by Abe Miessler

  Users need to be able to add a specific type of column to an otherwise static table on my web page and then save the information they enter in there to the database. I've been told that in reality they will almost never go over 5 columns but I would rather support N. The columns will all be of the same datatype. My first thought was to have an XML column with the values from all added columns in there but I was curious if anyone else had come up with a better solution. Suggestions?

  Read the article

• 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

• Is there was way to get the leftmost column in a Google visualization table to stay fixed while side

  - by Ben

  I'd looking to emulate the standard google visualization table header row behavior, but have it apply to the first column. This doesn't seem to be a built-in feature, but I'm wondering if it can be accomplished with some custom CSS?

  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

< Previous Page | 237 238 239 240 241 242 243 244 245 246 247 248  | Next Page >