Not sure how you may have this worked out but,
maybe #Form.conf_date# needs single quotes as well?
RO
>-----Original Message-----
>From: Tim [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 28, 2001 12: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
