remove the , after the comments = '#Form.comments#',
and it should work
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
----- Original Message -----
From: "Tim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 1:50 PM
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
