SELECT LAST_INSERT_ID() AS Ident

[rrufo]

en MM_editQuery tengo un insert a una bd mysql


' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.CommandText = "SELECT LAST_INSERT_ID() AS Ident"
Set rsLastIdent = MM_editCmd.Execute
session("MM_IDresiduo") = rsLastIdent.Fields.Item("Ident").Value
MM_editCmd.ActiveConnection.Close

pero me dice q fields no es un objeto valido


cosa de las versiones mysql? algun fallo tonto?
no se he mirado el insert y se ejecuta y el LAST_INSERT_ID() directo en mysql