Hi Bill,
On Mar 18, 2005, at 08:58, Bill wrote:
...I am trying to get the ID number of the last inserted record in a MySQL database. Can anyone help me do this?
put "SELECT LAST_INSERT_ID() from tripulantes" into dbQuery put revQueryDatabase(tConnection, dbQuery) into LastInsertID
I don't know if this is your problem or not, but I just use SELECT LAST_INSERT_ID() as the entire SQL command, omitting the "from..." part. I just just my MySQL user manual and I don't see the "from ..." as being a valid part of the command, unless maybe you are using a newer version than what I have.
--gordy
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
