Tim,
I don't believe that the %20 gets passed back to you when using
request.querystring(qParam) like syntax. The URLEncoded stuff will only
come across when you call the entire collection -- something like
strQueryVar = request.querystring .
Have you tried doing a response.write on both request.querystring("who") and
rstDBEdit("Cat_NAme") to see what they look like? I'd comment out the
redirects and place a write in there to see whats going on -- someting like:
if request.QueryString("who") <> "" then
response.write "## DEBUG : START ##<br>"
do WHILE NOT rstDBEdit.EOF
response.write " ==> " & request.querystring("who") & " : " &
rstDBEdit("Cat_NAme") & "<br>"
' if request.QueryString("who") = rstDBEdit("Cat_NAme") then
' response.redirect("add.asp")
' end if
rstDBEdit.movenext
loop
response.write "## DEBUG : END ##<br>"
response.end
' response.redirect("http://www.slo-pitch.com/provinces/"; &
request.QueryString("who") & "/gallery/add.asp")
END IF
HTH!
--Ben
----- Original Message -----
From: "Tim" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 7:44 AM
Subject: Re: using a dropdown to redirect
> Ben i treid the below code, but when i click submit soemthing that came
> from the db, it tries to go to the
>
> response.redirect("http://www.slo-pitch.com/provinces/"; &
> request.QueryString("who") & "/gallery/add.asp") link with the Cat_name
> as part of the url...
> i'm wondering if perhaps the do not match becuase the "who" has %20 in it
> due to spaces?
>
> ideas??
>
> > Tim,
> >
> > I believe the problem you're encountering lies within your do...loop
> > statement. The code below will never pass the first record because of
the
> > way you have the if...then statement setup -- it will redirect on the
first
> > iteration.
> >
> > I'd move the "hardset" url (the http://www.slo-pitch.com/provinces)
redirect
> > after do...loop -- something like:
> >
> > if request.QueryString("who") <> "" then
> > do WHILE NOT rstDBEdit.EOF
> > if request.QueryString("who") = rstDBEdit("Cat_NAme") then
> > response.redirect("add.asp")
> > end if
> > rstDBEdit.movenext
> > loop
> > response.redirect("http://www.slo-pitch.com/provinces/"; &
> > request.QueryString("who") & "/gallery/add.asp")
> > END IF
> >
> > You may also want to close/destroy the recordset before you do the
redirect
> > :-)
> >
> > HTH!
> >
> > --Ben
> >
> > ----- Original Message -----
> > From: <[EMAIL PROTECTED]>
> > To: "ActiveServerPages" <[EMAIL PROTECTED]>
> > Sent: Thursday, October 31, 2002 3:28 PM
> > Subject: using a dropdown to redirect
> >
> >
> > >
> > >
> > > I must be tired...i populate a dropdown from my db and hard code a
> > > part...and if someone picks on of my subjects from the db, i want to
> > > redirect to a certain place, if hard code, to another...i am doing
> > something
> > > wrong though...code is below.
> > >
> > > if request.QueryString("who") <> "" then
> > > do WHILE NOT rstDBEdit.EOF
> > > if request.QueryString("who") = rstDBEdit("Cat_NAme") then
> > > response.redirect("add.asp")
> > > else
> > > response.redirect("http://www.slo-pitch.com/provinces/"; &
> > > request.QueryString("who") & "/gallery/add.asp")
> > > end if
> > > rstDBEdit.movenext
> > > loop
> > > END IF
> > >
> > > ---
> > > You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED]
> > > To unsubscribe send a blank email to
> > %%email.unsub%%
>
> ---
> You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
