Discuss "Issue with ampersand &" in the ASP Development forum.

Rebelle · #1 April 17th, 2008, 09:54 AM

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.

jmurrayhead · #2 April 17th, 2008, 10:02 AM

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

Rebelle · #3 April 17th, 2008, 10:50 AM

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")) %>

richyrich · #4 April 17th, 2008, 10:54 AM

Quote:

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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

LinkBacks (?) LinkBack to this Thread: http://www.developerbarn.com/asp-development/132-issue-ampersand.html
Posted By	For	Type	Date
DeveloperBarn Forums - ASP Help, ASP.Net Help, PHP Help, SQL Help, Tutorials, Windows Help	This thread	Refback	April 26th, 2008 09:34 AM

The Following User Says Thank You to jmurrayhead For This Useful Post:
Rebelle (June 17th, 2008)

Discuss "Issue with ampersand &amp;" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.

Discuss "Issue with ampersand &" in the ASP Development forum.