I believe they're right Adam...
INSERT INTO table (poemID, rating, username)
VALUES (#url.id#, #form.rating#, #session.username#)
OR
UPDATE table (poemID, rating, username)
VALUES (#url.id#, #form.rating#, #session.username#)
WHERE poemID = '#url.id#'
>
> 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'.
>
>
