473,372 Members | 1,039 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Usage of If else statement/condition with radio buttons

Hi all,
I have created three radio buttons in my coldfusion page and working fine. But now i want to execute query, depending on the button selected.
ex:
Expand|Select|Wrap|Line Numbers
  1.     <td><input type="radio" name="Env" value="DEV" checked >
  2.             Dev</td> <td><input type="radio" name="Env" value="STG" checked >
  3.             STG</td> <td><input type="radio" name="Env" value="PRD" checked >
  4.             PRD</td>
My criteria is to execute a query related to Dev environment when Dev selected,
Execute a query related to STG environment when STG selected,
execute a query related to PRD environment when PRD selected
and to display the results.

My query is working fine but got struck at the if else loop
Kindly help me in achieving this. Thanks in advance
Mar 27 '13 #1
1 8207
acoder
16,027 Expert Mod 8TB
With radio buttons, the value is only passed if one of the buttons is selected. You can set a default with cfparam.

I see that you've checked all of the buttons. You should only have one selected by default. The browser will only select one anyway, but it will probably be the last one.

Are the queries very different? If so, you can simply use something like:
Expand|Select|Wrap|Line Numbers
  1. <cfif form.env EQ "DEV">
  2.     <cfquery ...>
  3. <cfelseif ...>
  4.     <cfquery ...>
If the queries are similar and the radio button selection only changes one line of the query, you could use something like:
Expand|Select|Wrap|Line Numbers
  1. <cfquery ...>
  2.     <cfif form.Env EQ "DEV">
  3.         <!--- DEV specific SQL --->
  4.     <cfelseif ...>
One last thing: cfswitch is an alternative to if/else.
Apr 9 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: sman | last post by:
Hi, I recently read this article on About.com on how to create required fields for a form: http://javascript.about.com/library/scripts/blformvalidate.htm Everything works great except that there...
10
by: DettCom | last post by:
Hello, I would like to be able to display or hide fields based on whether a specific Yes/No radio button is selected. This is in conjunction with a posting a just made here in the same group...
4
by: Oscar Monteiro | last post by:
I Have to sets of Radio buttons like so: <input type="radio" name=p1 value=1> <input type="radio" name=p1 value=2> <input type="radio" name=p1 value=3> <br> <input type="radio" name=p2 value=1>...
3
by: Syswatch | last post by:
Hi out there... I am pretty new to javascript, and is looking for some help here. I have a problem, I need a small javascript, which checks if there is any text in my textarea, and if it is NOT...
7
by: reon | last post by:
In the below code.. else statements didnt work correctly... the program is to add the positive and negative numbers... if we enter alphabets it will show the wrong entry ,, but thats not...
7
by: Milo333 | last post by:
Hi Please help, how do i write an if statement to check through 4 radio buttons, if none of the 4 buttons are selected than a message box must popup saying incomplete form, please complete the...
2
by: pradeep.thekkottil | last post by:
I'm setting up an auction website using PHP and MySQL. There in the section where logged in members can put up new auction in a form, I want to run a form validation where I used if else statements...
4
by: Blasting Cap | last post by:
I have a page that has a number of radio buttons that will be displayed to different access levels of a user who logs in to my website. For instance, if there are a dozen buttons, user1 will see...
11
by: Twayne | last post by:
Hi, Newbie to PHP here, no C or other relevant background, so pretty niave w/r to the nuances etc. but I think this is pretty basic. XP Pro, SP2+, PHP 4.4.7, XAMPP Local Apache Server...
10
by: =?Utf-8?B?UGFycm90?= | last post by:
I have 8 radio buttons on my Windows form but I can only select up to the first 4. If I click on any button beyond the 4th one and then come back into the program again the 4th button is always...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.