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]
