House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / ColdFusion Newbie (CF-Newbie)

What's Wrong with My Query?

Author:
Joel Polsky
03/12/2010 12:00 PM

Hi, It says "Incorrect syntax near the keyword 'WHERE'." Try quoting the value after the = sign WHERE poemID = '#url.id#' > > 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. > >


Search cf-newbie

February 11, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29