The reason that should not be there is because that is how the SQL parser
knows what the next Object is, a column or a command argument.
Thank You,
Peter
Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web Page: www.creatcomp.com
-----Original Message-----
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 2:01 PM
To: CF-Talk
Subject: RE: see a problem with this code?
How about the comma after this line? comments = '#Form.comments#',
don't think it should be there... though I'm kinda new at this stuff. :)
-----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
