hi
simple but i am stuck
i am having trouble saving date
i am using cf 4.5 win2000 and access.
Code below
<!--- SAVE to WDDX PACKET --->
<cfwddx action="CFML2WDDX" input="#surveyanswers#" output="data">
<!--- save to db --->
<cfquery name="addnewsurvey" datasource="#dsn#" username="#dsnUsername#"
password="#dsnPassword#">
insert into
survey (cfid,fname, lname, offercode, data, applied, date)
values (#Client.CFID#, '#form.fname#', '#form.lname#', '#form.offercode#',
'#data#', 1, '#now()#')
</cfquery>
Error
Error Report
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
SQL = "insert into survey (cfid,fname, lname, offercode, data, applied,
date) values (63, '432', '432142314', '65875',
'654363645tiutiu76980984324321423146587598797698National Geographic,New
ScientistYesYesYesYou do not wish to hear from an AUSTRALIAN GEOGRAPHIC
promotional partner,You do not wish to hear from AUSTRALIAN GEOGRAPHIC
againtiusubmit2349869', 1, '{ts '2004-06-01 13:38:26'}')"
Data Source = "AUSGEO"
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
