Adam, You're trying to insert a record into a table where the PoemID exists. If it's a new record, the ID doesn't exist. Are you trying to update a record? If so, you need to use an UPDATE Statement.
Update table Set ..... Where poemID = #url.id# Try that. Renee > 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:4980 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
