Hi,

How can I pass a querystring value that contains an & ?

I have it enclosed in quotes, which I thought would prevent problems.

I'm reading the information from a database - the actual line of code is:

<a href='ViewItem.asp?Category="BookCdDvd"&Item="<%= objRS("Item") %>"'><%= objRS("Item") %></a>


When I rest the mouse over the link, this is what's displayed in the status bar :

ViewItem?Category="BookCdDvd"&Item="Masked & Anonymous"


It keeps stopping at the &, and giving me this error :

Microsoft JET Database Engine (0x80040E14)
Syntax error in string in query expression 'Item = "Masked'.

Any suggestions?

Thanks,
Jennie.

Hi Jennie,

You need to use Server.URLEncode() for parameters in the querystring that can contain problem characters, not enclose them in quotes.

HTH,

Chris

Chris - you're a star!

The only fly in the ointment has been eliminated.

Thanks,
Jennie.

In the event I want to pass a value pulled from a database or cookie in a URL query string, as mentioned on this page, but don't want to show the querystring on the next page, how would I go about accomplishing this?