response.redirect("page.asp?id=???????")

[streborr]

How do I pass a value from a DB to open a new page that uses that value to return records where a field equals that value?

The sending page:

After all the connection stuff:

if trim(rsADO("user_group&quot) = "corp" then
response.redirect("corp.asp?user_company=(rsADO.user_Company)&quot
End if

After being sent to corp.asp, I want use the value from(rsADO.user_Company) in the SELECT:


The recieving page:

parent = (rsADO.user_Company)
connection stuff...
Select * From table Where Distributor = '" & parent & "'
rsADO.movefirst
do until rsADO.EOF
response.write("rsADO.dist_num&quot
rsADO.movenext
loop

rsADO.close
rsADO = nothing
%>

Thanks in advance for any help!
Rick

 

[link9]

parent = request.queryString("user_company&quot

 

[streborr]

link9,
I tried your suggestion, but it still doesn't work.

Do you think maybe the error is in this line from the sending page?

if trim(rsADO("user_group&quot) = "corp" then
response.redirect("corp.asp?user_company=(rsADO.user_Company)&quot
end if

thanks

 

[lobstah]

response.redirect("corp.asp?user_company=" & rsADO("user_Company&quot)

 

[streborr]

Thanks link9 and lobstah for the correct syntax!

That and I also added
<% response.buffer = clear %>
to the recieving page.

Everything is working perfect, thanks again.

Rick