Update Statement error

[ldebono]

Hello,

Ii'm receiving the syntax error listed below for my update statement. Doesn't
anyone have any ideas?


Syntax error or access violation: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right syntax
to use near 'WHERE softwareID = '3'' at line 4


83 : SET softwareName = '#trim(Form.softwareName)#',
84 : softwareVersion = '#trim(Form.softwareVersion)#',
85 : WHERE softwareID = #val(Form.softwareID)#;
86 : </cfquery>
87 :




--------------------------------------------------------------------------------

SQL UPDATE software SET softwareName = 'AOL Instant Messenger',
softwareVersion = '5.9', WHERE softwareID = '3';

[ldebono]

Sorry! I found the extra comma before the WHERE clause.

[paross1]

Get rid of the trailing comma after '5.9', and before WHERE:

UPDATE software
SET softwareName = 'AOL Instant Messenger', softwareVersion = '5.9'
WHERE softwareID = '3';

Phil