Re: [sqlite] How to access values of a columns with specific row id.

2012-01-31 Thread David Bicking
On 01/31/2012 04:05 AM, bhaskarReddy wrote: Hi Friends, Can any one tell me how to access values of a table column with its particular row id. I tried with "select * from ontTable where rowid=2;" I am getting the output as

Re: [sqlite] How to access values of a columns with specific row id.

2012-01-31 Thread Petite Abeille
On Jan 31, 2012, at 10:05 AM, bhaskarReddy wrote: > Can any one tell me how to access values of a table column with its > particular row id. In general, I would suggest that you get the basics straight: http://www.sqlite.org/books.html > I tried with "select * from ontTable where rowid=2;"

Re: [sqlite] How to access values of a columns with specific row id.

2012-01-31 Thread Larry Knibb
select columnName from ontTable where rowid = 2; select * gets you all of the columns for the row. select columnName will just get one column. Cheers, Larry On 31 January 2012 17:05, bhaskarReddy wrote: > > Hi Friends, > > >               Can any one tell me how to access

[sqlite] How to access values of a columns with specific row id.

2012-01-31 Thread bhaskarReddy
Hi Friends, Can any one tell me how to access values of a table column with its particular row id. I tried with "select * from ontTable where rowid=2;" I am getting the output as 1|2|3|XYZ234|4|ABCD123|5. Here i want the