Here's my code (basically)...

[Greg Jamison]

Here's what I'm basically doing (VBScript)...


mySQL = "INSERT INTO Users " _
& "(auto,text) " _
& "VALUES " _
& "(NULL,'text'); " _
& "SELECT LAST_INSERT_ID();"
set rsTemp = conntemp.Execute(mySQL)
usrID = rsTemp(0)
call closeRS(rsTemp)


But I'm getting an error that says...

[MySQL][ODBC 3.51 Driver][mysqld-4.0.16-standard-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT LAST_INSERT_ID()' at line 1

Help appreciated!