I have a problem using the LAST_INSERT_ID() in a particular installation. I
am running IIS on windows NT and accessing the MySQL database from an asp
page using ADO.
Here is the code I am using
SET objConn = Server.CreateObject("ADODB.Connection")
objConn.open connectionstring
objConn.execute "INSERT INTO T_Table (id,field1,field2) VALUES
(NULL,'value1','value2')"
SET objRS = objConn.execute("SELECT LAST_INSERT_ID()")
The page works as intended on our production server, however on our
development server, using exactly the same script the returned recordset
objRS, is always empty.
Obviously since the same script works on one machine and not on the other,
the problem lies with the set up. Unfortunately I don't know much of the
details of the set up, so can anyone make a guess as to what might be the
problem.
Thanks
Colin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
