--- Josh Mellicker <[EMAIL PROTECTED]> wrote:
>> After you execute a revExecuteSQL INSERT, how do you
>> get the auto-
>> incremented record ID MySQL automatically assigned
>> (from within Rev)?
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.
Ken Ray
Sons of Thunder Software
Web site: http://www.sonsothunder.com/
Email: [EMAIL PROTECTED]
_______________________________________________
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
