Hmmm... I tried both of these, and got a nice round zero as a
returned value in both cases, same as my earlier tests with
mysql_insert_id()...
My first instinct is that I need to do the INSERT using some other
command than revExecuteSQL? Because revExecuteSQL does not provide
for a "Record set"?
____________________
this info from http://www.mysqlfreaks.com/statements/90.php :
LAST_INSERT_ID([expr])
The last ID that was generated is maintained in the server on a per-
connection basis. This means the value the function returns to a
given client is the most recent AUTO_INCREMENT value generated by
that client. The value cannot be affected by other clients, even if
they generate AUTO_INCREMENT values of their own. This behaviour
ensures that you can retrieve your own ID without concern for the
activity of other clients, and without the need for locks or
transactions.
____________________
I have checked, and my pConnID/tDBRef is identical for both the
INSERT and the check for the insert_id.
I will keep trying to trace it down, could be simply related to how
I'm doing the insert or making the DB connection.
Thanks for the help!
On May 26, 2006, at 8:49 AM, Trevor DeVore wrote:
Try this:
function getLastInsertIDForMySQL pConnID
put "SELECT LAST_INSERT_ID()" into theSQL
return revDataFromQuery(,, pConnID, theSQL)
end getLastInsertIDForMySQL
On May 26, 2006, at 5:49 AM, Ken Ray wrote:
You can use revDataFromQuery right after you have done your insert
with
revExecuteSQL:
get revDataFromQuery("","",tDBRef,"SELECT LAST_INSERT_ID()")
You may also be able to use *another* call to revExecuteSQL to run
the same
SQL statement ("SELECT LAST_INSERT_ID()"), but I've only used
revDataFromQuery.
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
