Extracting text from request.querystring that contains ampersand

[JulesBos]

I originally posted this:

http://www.tek-tips.com/viewthread.cfm?qid=1368058&page=1

and have discovered that my problem is not my SQL, the problem is that I am trying to extract a string from my page's querystring that contains an ampersand, and everything after the ampersand is ignored. I have encoded the query string as follows:

Dim quoteResponseString As String = _
"Quotes/SearchResultsQuotes.aspx?QuoteID=" + CStr(QuoteID) + "&QuoteNo=" + QuoteNo + _
"&PN=" + QuotePN + "&RaiserID=" + QuoteRaiserID + "&RaiserName=" + QuoteRaiser + _
"&CustID=" + CStr(QuoteCustomerID) + "&CustName=" + QuoteCustomerName + _
"&Lifecycle=" + QuoteLifecycle + "&Breakdown=" + QuoteBreakdown + _
"&All=" + CStr(QuotesAll) + "&DateFrom=" + SelectedFromDate + _
"&DateTo=" + SelectedToDate
Server.UrlEncode(quoteResponseString)
Response.Redirect(quoteResponseString)

The query string looks like this:

http://localhost/GSContractsCSDs/Qu...&All=False&DateFrom=#00/00/00&DateTo=00/00/00

When I try and extract Breakdown I get "A" not "A&W".

How on earth do I resolve this one?

Potentially CustName, Lifecycle, or Breakdown could contain ampersands and I can't control that.

Thanks

Julia

 

[monksnake]

You can use the Server.URLEncode method on any item in the querystring that can contain an ampersand.

Do it on ONLY the querystring item:

"&Breakdown=" + Server.URLEncode(QuoteBreakdown) +

I tested this and it worked for me.






<.

 

[JulesBos]

That worked! Thanks very much.

Julia

 

[monksnake]

<.