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.
>
><CFQUERY name="additem" datasource="purchaseorders">
>INSERT INTO itemsordered
>(cnumber,
>line,
>qty,
>item,
>priceeach,
>totalprice
>)
>VALUES (#cnumber#,
>'#line#',
>'#qty#',
><cfqueryparam value="#Trim(item)#" cfsqltype="CF_SQL_VARCHAR">,
>'#trim(item)#',
>'#trim(totalprice)#'
>)
>Where cnumber = #cnumber#
></cfquery>
>
>Robert O.
>HWW
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
