Set qry string value based on radio btn selected

mikezx10 · March 21st, 2010, 09:57 AM

I have a page that i need to sort if the user selects the sort radio btn and then hit the link to reload the page.

I want to pass a 1 in the querystring for sort if the rb is checked and no querystring if the rb isnt checked.

How can i do this?
also once the rb is selected when i click it a second time it doesnt unselect

I just inherited a classic asp site and have 1 week experiance so all the help u can give apreciated

Thanks!
<%@ Language=VBScript %>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<%
dim sort, strSQL
sort=Request.QueryString("sort")

if sort=1 then
strSQL = strSQL & "ORDER BY Date Desc"
else
strSQL = strSQL & "ORDER BY fName"
end if
%>

<div id="SelFra" style="POSITION: absolute; WIDTH: 100%;">
<table width ="100%" border="0" cellspacing="0" align="center" >
<tr bgcolor="#aeaeae" >
<td style="width:200px;">  
<input type="radio" name="rbSort" value="0"
<% IF sort=1 then Response.Write "Checked" end if %> />  Sort by Account Size  
</td>
<td>
<a href="Default22.asp?sort=1" >Image</a>
</td>
</tr>
</table>
</div>
</body>
</html>

mat41 · March 21st, 2010, 05:51 PM

You shoulf post form variables as a first option. Querystrings should be used as little as possible. A whole nother topic there, trust me...

You could use an anchor tag and simply pass a QS. I have placed a <form> there and altered your code to achieve your objectivewitha form variable. Also you need to use a checkbox and not a radio button. You can turn a radio button off when there is only one option, you would need two radio buttons!!!

Anyhow - just rename pageName.asp to your page name in the "action'" part of the form tag. Apart from that the code is cut n paste

<%
dim sort, strSQL
sort = ""
sort=Request.form("rbSort")
if sort <> "" then
strSQL = strSQL & "ORDER BY Date Desc"
else
strSQL = strSQL & "ORDER BY fName"
end if
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<div id="SelFra" style="POSITION: absolute; WIDTH: 100%;">
<form name="updateForm" action="pageName.asp" method="post">
<table width ="100%" border="0" cellspacing="0" align="center" >
<tr bgcolor="#aeaeae" >
<td style="width:200px;">  <input type="checkbox" name="rbSort" <% if sort <> "" then response.write " checked " end if %> value="1" />  Sort by Account Size  </td>
<td><input type="submit" value="Sort"></td>
</tr>
</table>
</form>
</div>
</body>
</html>

mikezx10 · March 21st, 2010, 05:59 PM

Sweet, thanks buddy, it took me all day to figure out what you said, and its good to confirm i ended up in the right place.

Thank you very much!

Quote:

Originally Posted by mat41

You shoulf post form variables as a first option. Querystrings should be used as little as possible. A whole nother topic there, trust me...

You could use an anchor tag and simply pass a QS. I have placed a <form> there and altered your code to achieve your objectivewitha form variable. Also you need to use a checkbox and not a radio button. You can turn a radio button off when there is only one option, you would need two radio buttons!!!

Anyhow - just rename pageName.asp to your page name in the "action'" part of the form tag. Apart from that the code is cut n paste

<%
dim sort, strSQL
sort = ""
sort=Request.form("rbSort")
if sort <> "" then
strSQL = strSQL & "ORDER BY Date Desc"
else
strSQL = strSQL & "ORDER BY fName"
end if
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<div id="SelFra" style="POSITION: absolute; WIDTH: 100%;">
<form name="updateForm" action="pageName.asp" method="post">
<table width ="100%" border="0" cellspacing="0" align="center" >
<tr bgcolor="#aeaeae" >
<td style="width:200px;">  <input type="checkbox" name="rbSort" <% if sort <> "" then response.write " checked " end if %> value="1" />  Sort by Account Size  </td>
<td><input type="submit" value="Sort"></td>
</tr>
</table>
</form>
</div>
</body>
</html>