Can anyone tell me exactly what is causing this error ? ....
<!---Update using a CFQUERY with SQL UPDATE --->
<CFquery NAME="qUpdate" DATASOURCE="learncfe"> <!--- error --->
UPDATE GuestBook
SET (GuestName = '#Form.GuestName#',
Email = '#Form.Email#',
FirstVisit = #Form.FirstVisit#,
GotHere = '#Form.GotHere#',
Rating = '#Form.Rating#',
Comments = '#trim(Form.Comments)#')
WHERE GuestBook_ID = #Form.GuestBook_ID#
</CFquery>
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
statement.
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (43:5) to
(43:88).
Date/Time: 12/28/08 12:20:44
Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5)
Gecko/2008120122 Firefox/3.0.5
Remote Address: 127.0.0.1
HTTP Referer: http://localhost/tt380/GuestMaint.cfm?op=u&gid=1
Template: c:\inetpub\wwwroot\tt380\GuestUpdate.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317173
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
