Two things... It would help it you'd also post the SQL that the database is
trying to read. You can get this from the debug output.
Second thing... Your date should probably be formatted with the
CREATEODBCDATETIME() function
conf_date = #CreateOdbcDateTime(Form.conf_date)#
|-----Original Message-----
|From: Tim [mailto:[EMAIL PROTECTED]]
|Sent: Wednesday, March 28, 2001 1:50 PM
|To: CF-Talk
|Subject: see a problem with this code?
|
|
|I have a pre-filled form for users to change a record.
| The form calls an action page to update the record.
|I keep getting the dreaded error:
|
|Error Diagnostic Information
|ODBC Error Code = 37000 (Syntax error or access
|violation)
|[Microsoft][ODBC Microsoft Access Driver] Syntax error
|in UPDATE statement.
|
|I have looked backward and forward, checked spelling,
|quotes, etc., and can't figure out the problem. I
|figureed it was time for a new set of eyes. Is there
|something about this that I am missing:
|
|<CFQUERY NAME="qDoUpdate" DATASOURCE="teleconference">
|UPDATE data
|SET
|conf_name = '#Form.conf_name#',
|conf_purpose = '#Form.conf_purpose#',
|conf_date = #Form.conf_date#,
|occurance = '#Form.occurance#',
|begin_time = '#Form.begin_time#',
|end_time = '#Form.end_time#',
|mod_name = '#Form.mod_name#',
|mod_phone = '#Form.mod_phone#',
|mod_station = '#Form.mod_station#',
|poc_name = '#Form.poc_name#',
|poc_phone = '#Form.poc_phone#',
|poc_station = '#Form.poc_station#',
|facilities = '#Form.facilities#',
|comments = '#Form.comments#',
|WHERE ID = #Form.ID#
|</CFQUERY>
|
|I can add and view records in the database.
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
