Update price

[Robert Orlini]

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]

---