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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
needed direct page using database list
- Thread starter J304
- Start date
<%
set objRS = objCN.execute("SELECT idNum FROM myTable WHERE fieldName = '" & request("formField"
& "'"
if not objrs.eof
select case objRS("idNum"
case 1
response.redirect "Page1.asp"
case 2,3
response.redirect "page4.asp"
case else
response.write "Not found"
end select
else
response.write "Not found"
end if
%>
Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048
mikewolf@tst-us.com
set objRS = objCN.execute("SELECT idNum FROM myTable WHERE fieldName = '" & request("formField"
& "'"if not objrs.eof
select case objRS("idNum"
case 1
response.redirect "Page1.asp"
case 2,3
response.redirect "page4.asp"
case else
response.write "Not found"
end select
else
response.write "Not found"
end if
%>
Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048
mikewolf@tst-us.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question