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:
Maureen
03/12/2010 12:16 PM

There is no where clause on an insert.  If it exists, you need to update it. > > 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'.


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