The query from code: INSERT INTO table (poemID, rating, username) VALUES (#url.id#, #form.rating#, '#session.username#') WHERE poemID = #url.id#
Error details: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'. The error occurred in [pathToFile]\poemOverview.cfm: line 75 73 : INSERT INTO table (poemID, rating, username) 74 : VALUES (#url.id#, #form.rating#, '#session.username#') 75 : WHERE poemID = #url.id# 76 : </cfquery> 77 : SQLSTATE HY000 SQL INSERT INTO PoetryContest2010Ratings (poemID, rating, username) VALUES (5, 4, 'adgparke') WHERE poemID = 5 >From the error, it looks like the values are being passed, but the data isn't >written to the table and the page errors. I've tried moving single quotes around the values being inserted to no avail. Any help is appreciated. Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4978 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
