Hi,
The SQL in the CFQUERY would be something like:
UPDATE tblData SET
<cfswitch expression="your_radio_button">
<cfcase value="option_1_value">
Option1 = Option1 + 1
</cfcase>
<cfcase value="option_2_value">
Option1 = Option2 + 1
</cfcase>
<cfcase value="option_3_value">
Option1 = Option3 + 1
</cfcase>
</cfswitch>
When ran, it should create SQL like : UPDATE tblData SET Option1 =
Option1 + 1
- Rex
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5353
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
