2010/5/10 "Carlos Andrés Ramírez C." <i...@antai-group.com>: > > Hello guys, > I was breaking my head trying to figure out how to obtain the last > inserted row's ID --- using SQLite from Ruby. > > I found 'last_insert_rowid()' in your documentation at > http://www.sqlite.org/lang_corefunc.html and still did not do it. > > After spending a lot of time searching, I found that it was not > 'last_insert_rowid()' as documented, but instead 'last_insert_row_id()' > ---- with an extra underscore character before the 'id'. >
Nope. last_insert_rowid() is correct. Note that just doing a 'SELECT row_id FROM table' will croak with an error, while 'SELECT rowid FROM table' works fine. There is no underscore. I have $dbh->sqlite_last_insert_rowid() in Perl. Perhaps your Ruby SQLite package has changed the syntax and introduced the underscore. Get it corrected there. > is this a Typo? --- I almost went crazy > It was like that also in the downloadable documentation, so you wanna > check that out, > > Best wishes, > > Carlos Ramirez, > www.antai-group.com > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
