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.
Here is what I get when I pass to excel but don't get any records only the header info in the file.Code:location.href = "ResultsExcel.asp?RegionName=<%= sRegion %>&District=<%= strDistrict %>&Status=<%= strStatus %>
I've tried adding this to my resultsexcel.asp but still no luck with returning records.Code:http://server/folder/ResultsExcel.asp?RegionName=&District=&Status=In R&M
I'm thinking the problem is the & because I have other Status' without the & and those work just fine.Code:strStatus = Replace(Request("Status"),"&","& amp;")
Any help/suggestions is greatly appreciated.![]()



LinkBack URL
About LinkBacks


Bookmarks