M
magic2melody
Guest
i am trying add date value to my access database, it is succes on my local host, but isnt in my hosting
Line 159:
it returns:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
customers.asp, line 159
if i use '"&Replace(sDob,".","/")&"' it is working but i must use XX.XX.XXXX standart, not XX/XX/XXXX
please help me thank you very much
FULL OF CODE:
Session.LCID = 1055
If Request.Form("formName") <> "" Then
sDob = Request.Form("formBornDay")&"."&Request.Form("formBornMonth")&"."&Request.Form("formBornYear")
dbconn.Execute("INSERT INTO customers (cName,cUserName,cLastName,cMail,cTelephone,cMobile,cBorn,cPassword,cAddress) VALUES ('"&BadWordClean(Request.Form("formName"))&"','"&BadWordClean(Request.Form("formUserName"))&"','"&BadWordClean(Request.Form("formLastName"))&"','"&BadWordClean(Request.Form("formMail"))&"','"&BadWordClean(Request.Form("formTelephone"))&"','"&BadWordClean(Request.Form("formMobile"))&"','"&Replace(sDob,".","/")&"','"&BadWordClean(Request.Form("formPassword"))&"','"&BadWordClean(Request.Form("formAddress"))&"')")
End If
Line 159:
Code:
dbconn.Execute("INSERT INTO customers (cName,cUserName,cLastName,cMail,cTelephone,cMobile,cBorn,cPassword,cAddress) VALUES ('"&BadWordClean(Request.Form("formName"))&"','"&BadWordClean(Request.Form("formUserName"))&"','"&BadWordClean(Request.Form("formLastName"))&"','"&BadWordClean(Request.Form("formMail"))&"','"&BadWordClean(Request.Form("formTelephone"))&"','"&BadWordClean(Request.Form("formMobile"))&"','"&Replace(sDob,".","/")&"','"&BadWordClean(Request.Form("formPassword"))&"','"&BadWordClean(Request.Form("formAddress"))&"')")
it returns:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
customers.asp, line 159
if i use '"&Replace(sDob,".","/")&"' it is working but i must use XX.XX.XXXX standart, not XX/XX/XXXX
please help me thank you very much
FULL OF CODE:
Session.LCID = 1055
If Request.Form("formName") <> "" Then
sDob = Request.Form("formBornDay")&"."&Request.Form("formBornMonth")&"."&Request.Form("formBornYear")
dbconn.Execute("INSERT INTO customers (cName,cUserName,cLastName,cMail,cTelephone,cMobile,cBorn,cPassword,cAddress) VALUES ('"&BadWordClean(Request.Form("formName"))&"','"&BadWordClean(Request.Form("formUserName"))&"','"&BadWordClean(Request.Form("formLastName"))&"','"&BadWordClean(Request.Form("formMail"))&"','"&BadWordClean(Request.Form("formTelephone"))&"','"&BadWordClean(Request.Form("formMobile"))&"','"&Replace(sDob,".","/")&"','"&BadWordClean(Request.Form("formPassword"))&"','"&BadWordClean(Request.Form("formAddress"))&"')")
End If