On 8 May 2011, at 4:00pm, Sam Carleton wrote: > How does one go about finding out how many rows a query returns?
This was asked earlier this week. There is no magic way. Step through the rows and count them. You can, of course, do a preliminary SELECT for 'count(*)' and see what answer is returned. > Is there a > way to find out the id of a particular column? It depends what you think a column's id is. But SQLite maintains a pseudo-column of INTEGERs called 'id' or 'rowid' (several other names) which you can ask for by name. For instance SELECT rowid,* FROM myTable Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users