mySQL and VBscript

Here's the code we have: Set objConn = Server.CreateObject("ADODB.Connection") objconn.Mode = adModeReadWrite objConn.Open "dsn=myDSN" ... vLastIndex = objConn.Execute("SELECT LAST_INSERT_ID()").Fields(0).Value Here's what we got Explorer just prompts: Microsoft OLE DB Provider for ODBC D

selecting records where max value

Hi ! is there any way to do this ? SELECT T2.monedaID, T2.fecha, T1.descripcion, T2.compra, T2.venta FROM UYMonedasBCU T1, UYMonedasCotizaInter T2 WHERE (T2.fecha = (SELECT DISTINCT MAX (T3.fecha )FROM uymonedascotizainter T3 )) AND (T1.forma = 'Billete') AND (T2.monedaID = T1.id ) The matt