I have this two pages:
on my region.asp:
<html>
......
<form name="regform" action=region_action.asp method=post>
<table BORDER="0" WIDTH="486" background="greenps.gif">
<TR><td><input type="radio" name=region onclick="location.href='region_action.asp?region=2500'>
SouthWest</td>
<td><input type="radio" name=region onclick="location.href='region_action.asp?region=2501'">
New England</td>
<td><input type="radio" name=region onclick="location.href='region_action.asp?region=2502'">
Mid-Atlantic</font></td></TR>
and on the region_action.asp:
<%@ language=....%>
region_no = Request.Form("region"
Set hertzDB = Server.CreateObject("ADODB.Connection"
caseDB.Open dbCase
strtext = "select * from area_name where area_no = '" & region_no & " ' "
set regionset=caseDB.Execute(strtext)
if staffset.Eof then
%>
<b>No listing available for this region</b>
<%
else
staffset.movefirst
The code on the region_action.asp "region_no = Request.Form("region"" don't seem to work. I know my sql works because when I hard-code a value to it, the table gets displayed.
I'm laboring on this for a few days now, I might have missed something, any help will be gratly appreciated.
on my region.asp:
<html>
......
<form name="regform" action=region_action.asp method=post>
<table BORDER="0" WIDTH="486" background="greenps.gif">
<TR><td><input type="radio" name=region onclick="location.href='region_action.asp?region=2500'>
SouthWest</td>
<td><input type="radio" name=region onclick="location.href='region_action.asp?region=2501'">
New England</td>
<td><input type="radio" name=region onclick="location.href='region_action.asp?region=2502'">
Mid-Atlantic</font></td></TR>
and on the region_action.asp:
<%@ language=....%>
region_no = Request.Form("region"
Set hertzDB = Server.CreateObject("ADODB.Connection"
caseDB.Open dbCase
strtext = "select * from area_name where area_no = '" & region_no & " ' "
set regionset=caseDB.Execute(strtext)
if staffset.Eof then
%>
<b>No listing available for this region</b>
<%
else
staffset.movefirst
The code on the region_action.asp "region_no = Request.Form("region"" don't seem to work. I know my sql works because when I hard-code a value to it, the table gets displayed.
I'm laboring on this for a few days now, I might have missed something, any help will be gratly appreciated.