QueryString problems 1

[Manic]

I am trying to put 2 items into a querystring and then extract them.

This is the code I am using.

To Post
"Link.asp?Branch=<%=R%> Dept=<%=S%>"

To retrive
R = CStr(Request.QueryString("Branch"))
S = CStr(Request.QueryString("Dept"))

To Display
strSQL = "SELECT * FROM PC WHERE Branch='" & R & "' and Dept='" & S & "' ORDER BY IP, User"

Is it possible and if so could you let me know how to do it.

This has become quite frustrating.

Thanks in advance for any help.

___________________
Manic

http://www.rockatpzazz.com

 

[FateFirst]

"Link.asp?Branch=<%=R%>&Dept=<%=S%>"

- FateFirst

 

[FateFirst]

What sort of problems are you having then?

- FateFirst

 

[Manic]

Thanks FateFirst,

I was being stupid, I had a space in the '> & Dept' and the section I was doing there was a '&' in the department name.

Both of which threw me.

What I have got is a Asset list and I can go into each site and now per department for each site.

Makes it a lot easire whan checking kit off.

Thanks again for your help

___________________
Manic

http://www.rockatpzazz.com