Thread: Issue with ampersand &

Hi All,

I have a field "Status" where some of the data is:
-In R&M

This is the status field where the data is stored. I can get results when I search the status field using the "In R&M" selection but I'm passing the status when i'm exporting to excel file, like below.

Code:

location.href = "ResultsExcel.asp?RegionName=<%= sRegion %>&District=<%= strDistrict %>&Status=<%= strStatus %>

Here is what I get when I pass to excel but don't get any records only the header info in the file.

Code:

http://server/folder/ResultsExcel.asp?RegionName=&District=&Status=In R&M

I've tried adding this to my resultsexcel.asp but still no luck with returning records.

Code:

strStatus = Replace(Request("Status"),"&","& amp;")

I'm thinking the problem is the & because I have other Status' without the & and those work just fine.

Any help/suggestions is greatly appreciated.

Thanks JMurrayhead!!!!

Using this now and all seems to be good.

Code:

location.href = "ResultsExcel.asp?RegionName=<%= sRegion %>&District=<%= strDistrict %&Status=<%= Server.UrlEncode(Request("Status")) %>

Originally Posted by jmurrayhead

You need to use Server.UrlEncode() to encode the querystring.

Can't give you rep so I'll just say I agree!