mi dice
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/sito2/agenda.asp, line 148
questa è la stampata della query
SELECT * FROM agenda WHERE Data >='' ORDER by Data
questo è lo script
codice:function prepara_data(gg,mm,aaaa) data= gg & "/" & mm & "/" & aaaa response.Write data end function call prepara_data(datePart("d",now()), datePart("m",now()), datePart("yyyy",now())) Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" &_ "DBQ="& Server.MapPath("/mdb-database/auriga.mdb") sql = "SELECT * FROM agenda WHERE Data >='" & data & "' ORDER by Data"

Rispondi quotando