UPDATE bookinfo
SET percentage = <cfqueryparam cfsqltype="CF_SQL_NUMERIC"
value="#form.percentage#">
> -----Original Message-----
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 30 maart 2004 17:50
> To: CF-Talk
> Subject: RE: Update price
>
> I get an error Peter (see below). I want to update all in the
> percentage column to the value of form.percentage (which will
> be 0) and in each of those records I want discountedprice to
> be set to the same as the price value. Discountedprice, price
> are decimal fields.
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:
> Incorrect syntax near '@P1'.
> SQL = "Update bookinfo ? , discountprice = price Where bookid
> = 4" Query Parameter Value(s) - Parameter #1 = 0 Data Source
> = "PRINTPRICES"
>
>
> Code is:
> <cfif IsDefined("form.percentage")>
> <CFQUERY name="change" datasource="printprices"> Update
> bookinfo <cfqueryparam cfsqltype="CF_SQL_NUMERIC"
> value="#form.percentage#"> , discountprice = price Where
> bookid = 4 </cfquery> done </cfif>
>
> -----Original Message-----
> From: Pascal Peters [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 10:38 AM
> To: CF-Talk
> Subject: RE: Update price
>
>
> SET percentage = <cfqueryparam cfsqltype="CF_SQL_NUMERIC"
> value="#form.percentage#"> ,
> discountprice = price
> WHERE ...
>
> Assuming your percentage is numeric. I see you have quotes
> around it, so mayby it's a varchar (CF_SQL_VARCHAR)
>
> Don't forget the WHERE clause or you will update all records
> in the table
>
> > -----Original Message-----
> > From: Robert Orlini [mailto:[EMAIL PROTECTED]
> > Sent: dinsdag 30 maart 2004 17:24
> > To: CF-Talk
> > Subject: Update price
> >
> > I have a query in an action page where I set a column to 0 (from a
> > form) and update discountedprice to the same value as
> price. Here is
> > the code:
> >
> > <CFQUERY name="change" datasource="printprices"> Update
> bookinfo SET
> > percentage = '#form.percentage#'
> > SET 'discountedprice' = 'price'
> > </cfquery>
> >
> > I'm kinda a newy to all this so of course it doesn't work. I get an
> > error with -- SET 'discountedprice' = 'price'
> >
> > Any ideas please? Thanks.
> >
> > Robert O.
> > HWW
> >
> >
> _____
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
