Express - syntax error ... CFQUERY > UPDATE

[BowlerBob]

Can anyone see what this error actually is ?

<!---Update using a CFQUERY with SQL UPDATE --->
<CFquery NAME="qUpdate" DATASOURCE="learncfe">
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\

http://wwwroot\tt380\GuestUpdate.cfm

 

[LyndonOHRC]

SET (GuestName = '#Form.GuestName#',
Email = '#Form.Email#',
FirstVisit = #Form.FirstVisit#,
GotHere = '#Form.GotHere#',
Rating = '#Form.Rating#',
Comments = '#trim(Form.Comments)#')

Take off the parentheses.

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[BowlerBob]

Great, thanks.

 

[LyndonOHRC]

Is your database open on your desktop?

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey