Dear Experts,
I keep getting the following error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/ORG/HRM/medewerkertoevoeg.asp, line 50
I treid different solutions but here is the code:
It is fine i think , i treid to free the integer value from the string but the result is the same. The code above is with freeing of integers and the code below without:
the result (response.write strsql):
Insert Into Medewerker(Med_nr,afd_id,Med_naam,Med_voor,Med_tus 1,Med_tus2,Med_roep,Med_ini,Med_tel,Med_email,Med_ mutdat,Med_gebdatum,Med_indienst,Afwezig op,Med_mobiel,Funktie_id,werkstatus)VALUES ('10000','28','Meussen','F','der','der','Koen','FM ','6578','f.meussen@planet.nl','4/3/2006 12:56:37 PM','02/03/1982','04/08/2000','Woensdag,Dinsdag','06-42726465','27','Stagiair'); Uw gegevens voor het smoelenboek zijn verwerkt bedankt.
what am i doing wrong here?
I keep getting the following error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/ORG/HRM/medewerkertoevoeg.asp, line 50
I treid different solutions but here is the code:
Code:
StrSQL = "Insert Into Medewerker(Med_nr,afd_id,Med_naam,Med_voor,Med_tus 1,Med_tus2,Med_roep,Med_ini,Med_tel,Med_email,Med_ mutdat,Med_gebdatum,Med_indienst,Afwezig op,Med_mobiel,Funktie_id,werkstatus)"& _
"VALUES ('"& Request.Form("med_nr") &"'," & Request.Form("mainselect")& ","& _
"'"& Request.Form("med_naam") &"','"& Request.Form("med_voor") &"','"& hulptus1 &"','"& hulptus2 &"',"& _
"'"& Request.Form("med_roep") &"','"& Request.Form("med_ini") &"','"& Request.Form("med_tel") &"','"& Request.Form("med_email") &"','"& datumnu &"',"& _
"'"& geboortesamenvoeging &"','"& indienstsamenvoeging &"','"& Request.Form("Med_afwezigop") &"','"& Request.Form("Med_mobiel") &"'," & Request.Form("mainselect2")& ",'"& Request.Form("Werkstatus") &"');"
It is fine i think , i treid to free the integer value from the string but the result is the same. The code above is with freeing of integers and the code below without:
Code:
StrSQL = "Insert Into Medewerker(Med_nr,afd_id,Med_naam,Med_voor,Med_tus 1,Med_tus2,Med_roep,Med_ini,Med_tel,Med_email,Med_ mutdat,Med_gebdatum,Med_indienst,Afwezig op,Med_mobiel,Funktie_id,werkstatus)"& _
"VALUES ('"& Request.Form("med_nr") &"','" & Request.Form("mainselect")& "',"& _
"'"& Request.Form("med_naam") &"','"& Request.Form("med_voor") &"','"& hulptus1 &"','"& hulptus2 &"',"& _
"'"& Request.Form("med_roep") &"','"& Request.Form("med_ini") &"','"& Request.Form("med_tel") &"','"& Request.Form("med_email") &"','"& datumnu &"',"& _
"'"& geboortesamenvoeging &"','"& indienstsamenvoeging &"','"& Request.Form("Med_afwezigop") &"','"& Request.Form("Med_mobiel") &"','" & Request.Form("mainselect2")& "','"& Request.Form("Werkstatus") &"');"
the result (response.write strsql):
Insert Into Medewerker(Med_nr,afd_id,Med_naam,Med_voor,Med_tus 1,Med_tus2,Med_roep,Med_ini,Med_tel,Med_email,Med_ mutdat,Med_gebdatum,Med_indienst,Afwezig op,Med_mobiel,Funktie_id,werkstatus)VALUES ('10000','28','Meussen','F','der','der','Koen','FM ','6578','f.meussen@planet.nl','4/3/2006 12:56:37 PM','02/03/1982','04/08/2000','Woensdag,Dinsdag','06-42726465','27','Stagiair'); Uw gegevens voor het smoelenboek zijn verwerkt bedankt.
what am i doing wrong here?