> -----Original Message-----
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: 09 July 2004 15:18
> To: CF-Talk
> Subject: 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 (#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]
