SOT: keyword 'Where' error

Is there a problem with this Insert? I get an Incorrect syntax near the keyword 'Where' error. I added single quotes around #cnumber# and still get the error. CFQUERY name=additem datasource=purchaseorders INSERT INTO itemsordered (cnumber, line, qty, item, priceeach, totalprice ) VALUES

Re: SOT: keyword 'Where' error

Yes, you cannot specify a where clause in an insert. If you are updating a row then use update not insert. Doug Robert Orlini wrote: Is there a problem with this Insert? I get an Incorrect syntax near the keyword 'Where' error. I added single quotes around #cnumber# and still get the error.

RE: SOT: keyword 'Where' error

Thanks all. Too many cut-and-pastes and I didn't pay attention. Also, still am a newbie on some of this. Robert O. -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Friday, July 09, 2004 9:26 AM To: CF-Talk Subject: Re: SOT: keyword 'Where' error Yes, you cannot