|
Mailing Lists
|
Home / Groups / ColdFusion Newbie (CF-Newbie)
What's Wrong with My Query?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. |
February 11, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||