Problem med dato
Jeg har stirret mig blind på denne kode, er der nogen der kan hjælpe mig med at få rettet den. Jeg tror den er gal med datoen.Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=c:\www\fmpartner.dk\dynamicinn\db\database.mdb"
Conn.Open DSN
strSQL = "Insert into shop_orders ("
strSQL = strSQL & "kundeid, "
strSQL = strSQL & "ordrer, "
strSQL = strSQL & "levering, "
strSQL = strSQL & "leveringsdato, "
strSQL = strSQL & "notat, "
strSQL = strSQL & "betaling, "
strSQL = strSQL & "dato, "
strSQL = strSQL & "godkendt) "
strSQL = strSQL & "values( "
strSQL = strSQL & "'" & Session("kundeid") & "', "
strSQL = strSQL & "'" & Teksten & "', "
strSQL = strSQL & "'" & Request.Form("levering") & "', "
strSQL = strSQL & "'" & Request.Form("leveringsdato") & "', "
strSQL = strSQL & "'" & Request.Form("notat") & "', "
strSQL = strSQL & "'" & Request.Form("betaling") & "', "
strSQL = strSQL & "'" & Request.Form("dato") & "', "
strSQL = strSQL & "'Ja')"
Conn.Execute(strSQL)
Conn.Close
Set Conn = Nothing
Fejlen hedder:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/confirm.inc, line 83
Linje 83 er: "Conn.Execute(strSQL)"
