Search Results

Search found 29811 results on 1193 pages for 'table of contents'.

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

• i want to add a column in my table.. can any body help me for that..

  - by Abid

  there is already some columns added in my table starsin.. i want to add a column address in my table starsin by using a query..

  Read the article

• How to get number of entries in a Lua table?

  - by romkyns

  Sounds like a "let me google it for you" question, but somehow I can't find an answer. The Lua # operator only counts entries with integer keys, and so does table.getn: tbl = {} tbl["test"] = 47 tbl[1] = 48 print(#tbl, table.getn(tbl)) -- prints "1 1" count = 0 for _ in pairs(tbl) do count = count + 1 end print count -- prints "2" How do I get the number of all entries?

  Read the article

• What could be the Consequence of inserting "id" in any autoincrementing 'id' containing table?

  - by Parth

  What could be the Consequence of inserting "id" in any autoincrementing 'id' containing table? If I have a Tabe in which I have configured the column "id" as the auto incrmented, But still I am using an INSERT query in which id is defined, like wise INSERT INTO XYZ (id) values ('26'); How does it going to effect the table and the process related to it.. Is it "no issues" to do this? or it should be avoided?

  Read the article

• How do I map to a parent or child in the same table with NHibernate?

  - by adolfojp

  Lets suppose that I have a Category table with a column that holds the id of a parent or child category from the same table. This design would allow me to have unlimited levels of Categories, or unlimited levels in a thread, for example. How can I map this relationship with NHibernate? Are there any disadvantages or warnings that I should take into consideration when doing this?

  Read the article

• screen shots on how to modify queries in postgresql table created?

  - by pallav

  my tomcat server is showing error 500 exception. actually i am not able to get connected to the table created in the pg admin3 postgresql database to the project deployed in the server. can u please tell me the method to modify query in the table created?

  Read the article

• Allow users to pull temporary data then delete table?

  - by JM4

  I don't know the best way to title this question but am trying to accomplish the following goal: When a client logs into their profile, they are presented with a link to download data from an existing database in CSV format. The process works, however, I would like for this data to be 'fresh' each time they click the link so my plan was - once a user has clicked the link and downloaded the CSV file, the database table would 'erase' all of its data and start fresh (be empty) until the next set of data populated it. My EXISTING CSV creation code: <?php $host = 'localhost'; $user = 'username'; $pass = 'password'; $db = 'database'; $table = 'tablename'; $file = 'export'; $link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error()); mysql_select_db($db) or die("Can not connect."); $result = mysql_query("SHOW COLUMNS FROM ".$table.""); $i = 0; if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { $csv_output .= $row['Field'].", "; $i++; } } $csv_output .= "\n"; $values = mysql_query("SELECT * FROM ".$table.""); while ($rowr = mysql_fetch_row($values)) { for ($j=0;$j<$i;$j++) { $csv_output .= '"'.$rowr[$j].'",'; } $csv_output .= "\n"; } $filename = $file."_".date("Y-m-d",time()); header("Content-type: application/vnd.ms-excel"); header("Content-disposition: csv" . date("Y-m-d") . ".csv"); header( "Content-disposition: filename=".$filename.".csv"); print $csv_output; exit; ?> any ideas?

  Read the article

• how to select only first td of first colgroup of table?

  - by metal-gear-solid

  how to select only first td of first colgroup of table? if i have table with 5 column and using 5 colgroup?

  Read the article

• How do I escape reserved words used as column names? MySQL/Create Table

  - by acidzombie24

  I am generating tables from classes in .NET and one problem is a class may have a field name key which is a reserved MySQL keyword. How do I escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique) create table if not exists misc_info ( id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL, key TEXT UNIQUE NOT NULL, value TEXT NOT NULL)ENGINE=INNODB;

  Read the article

• Copy a table from an SQL Server CE 3.5 database to another in Visual Studio 2008?

  - by ipapasa

  How can I copy a table from an SQL Server CE 3.5 database to another (also CE database) in Visual Studio 2008, using the design tools? Note: When right clicking on a table there is a "copy" command, but I couldn't find any "paste" command so far...

  Read the article

• How can we get an autogenerated Id from the Table While Inserting?

  - by SAHIL SINGLA

  How can we get an autogenerated Id from the Table While Inserting? I have three tables Project ProjectXMilestone Milestone and on Insert of Milestone I also want to insert a row in 2nd Table so I need MilestoneId?so how can I get that? I am using Linq.

  Read the article

• How do i escape reserve names in a column? MySQL/Create Table

  - by acidzombie24

  I am generating tables from classes in .NET and one problem is a class may have a field name key which is a reserved mysql keyword. How do i escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique) create table if not exists misc_info ( id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL, key TEXT UNIQUE NOT NULL, value TEXT NOT NULL)ENGINE=INNODB;

  Read the article

• can we have a foreign key which is not a primary key in any other table?

  - by Mac

  it is written in every book that foreign keys are actually primary key in some other table but can we have a foreign key which is not primary key in any other table

  Read the article

• UITableView Scrolling Performance and semitransparent views - does it matter only in the table?

  - by mystify

  I have a UITableView which only takes like 3/4 of the screen, but not the entire screen. Now I wonder if it matters to scrolling performance a lot, if outside the UITableView there are views with alpha 0.5? When a table view scrolls, is the entire screen affected with compositing and drawing, or only the frame of the table view?

  Read the article

• Whats query can be used to get the details of Indexes of any table?

  - by Parth

  Whats query can be used to get the details of Indexes of any table? I need this to find out primarykey/autoincremented value of any table.. Please help/Guide me...

  Read the article

• How to select with Linq to Entity from one table with two different variables?

  - by George

  I have a table where I have items under two different types as you can see below: How can I select from this table with Linq to Entity to get the result with two variables? where ItemType = Type1 and ItemType == Type2 .... select new {typeOne == "", typeTwo == ""}; ID ItemName ItemType 1 ItemOne Type1 2 ItemTwo Type1 3 ItemThree Type1 4 ItemFour Type1 5 ItemTFive Type2 6 ItemSix Type2 7 ItemSeven Type2 8 ItemEight Type2

  Read the article

• one to many mapping within the same table in Hibernate..

  - by saurabh

  I have a table containing primary key and foreign key that references same table. How can I implement this mapping in hibernate...

  Read the article

• mySQL: How many rows in a table before performance is affected?

  - by Industrial

  Hi everybody, Is there a "known limit" for columns & rows in a mySQL table that when passed, it can be safe to say that performance is severely affected? I've think that I had heard that there is a "golden number" that you really dont want to exceed in either columns or rows in a table. - Or is it all about the size of the index and available RAM + CPU on the server? Thanks!

  Read the article

• How do I add a custom table to a form in another module in Drupal?

  - by Kareed

  I am trying to make a module to add a table to a form in another module. I found I can add the new data in a module_form_alter hook but how to I get it to run through a theme hook? The module I am trying to modify has a theme hook for the page I want to modify. I don't want to change the original form I just want to add a table with new data below it. Thanks

  Read the article

• How to hook onclick event for each cell in a table in Javascript?

  - by MartyIX

  I was thinking if there's a better solution for adding onclick handler to each cell in a table than this approach: http://stackoverflow.com/questions/1207939/adding-an-onclick-event-to-a-table-row Better in the way that I wouldn't need to set "cell.onclick = function" for each cell. I just need to get the coordinations of a cell where user clicked. Thanks!

  Read the article

• Reading from a very large table using multiple threads (Java ) and writing them to a single file

  - by user2534926

  I am currently facing a situation where i have a table with almost 80 millions data and i have to take a dump of that table and store it into a csv file. Currently i am using a not so professional approach( with a perl script+DBI interface , printing the values to stdout and redirecting to a csv file). Now i am planning to use java threading approach. Can you suggest a way forward. Thanks in advance

  Read the article

• What are the model, lft, and rght fields used in the acos table?

  - by takabanana

  What are the cakePHP usages/meanings of the model, lft, and rght fields in a acos table? Similarly, what are the usages/meanings of the lft and rght fields in a aros table?

  Read the article

• How add a Primary Key autoincremented on my existing table ?

  - by xRobot

  I have a table with some datas. Is there a way to add a PK without erase the table ?

  Read the article

• Does apple mind you using that striped table view background in your own views?

  - by Dave

  The ones they use with grouped table view. I'm using a table view that links to another view that has text on it. To make it look less 'plain' I wanted to add that striped background and then put something like a white 'text box' on that. Do they allow it to be used?

  Read the article

• How do I change a MySQL table to UTF-8?

  - by alex

  I know there are many settings for a language for a table and a database. I already created the database. I believe when I created it, it was default/LATIN. I want to change everything-I mean...both the table and the database, to UTF-8. How can I do that? thanks.

  Read the article

• methods of joining 2 tables without using JOIN or SELECT more than one distinct table in the query

  - by GB_J

  Is there a way of joining results from 2 tables without using JOIN or SELECT from more than one table? The reason being the database im working with requires queries that only contain SELECT, FROM, and WHERE clauses containing only one distinct table. I do, however, need information from other tables for the project i'm working on. More info: the querier returns the query results in a .csv format, is there something we can manipulate there?

  Read the article

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