Can anybody tell me how to get the record ID of a newly added record after updating the recordset ?
With MS Access as back end for our web application we used to do
rs.Open "SELECT * FROM table WHERE ID = -1)
rs("field1") = value1
rs("field2") = value2
newID = rs("ID")
But this doesn't seem to work with MySQL (4.0.11) and MyODBC (3.51.06)
Any ideas ?