-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 10:24 AM
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]
