I’m trying to do a simple select count(*) from table and would like to simply fetch the row into a variable. I’ve tried the methods listed here:
http://www.nessie.de/mroth/lua-sqlite3/documentation.html#ref8
Unfortunately Corona doesn’t seem to support these single row methods. The only way I know to do it currently is to go ahead and wrap it into the “for row in db:nrows” method given in the SQLite example on this site. But that’s about like using a for loop to set x=1.
Any way to fetch a single row?
[import]uid: 8776 topic_id: 2336 reply_id: 302336[/import]