...

View Full Version : Data type mismatch in criteria expression.



jarv
03-26-2009, 04:54 PM
from my code:
SQL


sSQL = "UPDATE tEvents SET rsTitle='"&rsTitle&"', rsName='"&rsName&"', rsCompany='"&rsCompany&"', rsEmail='"&rsEmail&"', rsTelephone='"&rsTelephone&"' WHERE Start_Date = '"&Start_Date&"' AND eventTime = '"&eventTime&"' "


objConn.Execute(sSQL)




when i response.write my SQL I get the following:

UPDATE tEvents SET rsTitle='Mr', rsName='John', rsCompany='biddy', rsEmail='john@john.com', rsTelephone='07939996' WHERE Start_Date = '14/05/2009' AND eventTime = '09:00'



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum