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 <uni...@gmail.com> 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 1|2|3|XYZ234|4|ABCD123|5. > > Here i want the values of column should store in separate > variables. > > > Can any one tell me how to access column by column. > > > Regards, > Bhaskar Reddy. > > > > > -- > View this message in context: > http://old.nabble.com/How-to-access-values-of-a-columns-with-specific-row-id.-tp33234692p33234692.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users