radio buttons and asp

georgeous · Mar 5, 2002

Hi, I was wondering if anybody could help me.

I have a simple html page which has a form with radio buttons that links to an asp page. When a user a selects a button and clicks submit, I would like to run a piece of sql dependent on the value of the radio button.
can i use if, then and else statements, and if so, how do i lay them out

thanks

dbrom · Mar 5, 2002

Can you be more specific?

What kind of SQL statements would you need to run and how does it differ based on radio control values?

[sadeyes]

<Dmitriy>
dbrom@crosswinds.net

georgeous · Mar 5, 2002

basically, it is a page that searches a database and returns values.
The radio buttons determine what the query searches for,

e.g radio button 1 = would search for items containing the word "fish"

radio button 2 would search for items containing the word "chips"

my sql queries are correct and everything, I just don't know how to call them from the radio buttons.

does this make it clearer?

AgentM · Mar 5, 2002

Hoping that you are using method=post for the form.

You can use
if Request.form("radio1&quot

= "on" then
sql=
elseif Request.form("radio2&quot

= "on" then
sql=
else

end if

Hope this helps.

georgeous · Mar 5, 2002

thanks so much for that.
I'll try it tommorrow when I get back into uni.
Thanks again

georgina

chinnababu · Mar 5, 2002

Try this. This form submits to it self.
and save this as 'caseSelection.asp'
----------------------------------
<html>
<head>
<title>Untitled</title>
</head>

<body>
<form action="caseSelection.asp" method="post">
<input type="radio" name="caseSelection" value="1"> Choice One<br>
<input type="radio" name="caseSelection" value="2"> Choice Two<br>
<input type="radio" name="caseSelection" value="3"> Choice Three<br>
<input type="submit" name="submit" value="Submit">
</form>

<%
Dim GotoCaseSelection
GotoSelection = Request.Form("caseSelection&quot

If GotoSelection = "1" Then
Response.Redirect "

http://www.cnn.com"

ElseIf GotoSelection = "2" Then
Response.Redirect "

http://www.chinnababu.net"

ElseIf GotoSelection = "3" Then
Response.Redirect "test.asp"
Else
Response.Write "wrong selection."
End If

%>

</body>
</html>

vincentius · Mar 5, 2002

georgeous,

Try this, trial.asp

<html>
<head>
<title>Untitled</title>
</head>

<body>
<form action="trial.asp" method="post">
<input type="radio" name="test" value="fish">Fish<br>
<input type="radio" name="test" value="chips">Chips<br>
<input type="submit" value="Submit">
</form>

<%
testing = Request.Form("test&quot

if testing = "fish" then
mySQL = ...
else
if testing = "chips" then
mySQL = ...
end if
end if

(then you can execute your SQL here)

Hope it helps.

Vincent.

%>

</body>
</html>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

radio buttons and asp

georgeous

Programmer

dbrom

Programmer

georgeous

Programmer

AgentM

MIS

georgeous

Programmer

chinnababu

IS-IT--Management

vincentius

Programmer

Similar threads

Part and Inventory Search

Sponsor