[thelist] ASP - & Encoding

[Feingold Josh S]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
> Have you tried response.write'ing your query to see what value is going in
the
> WHERE clause?

Yes, I got "AT&T".

The issue seems to be that with my query:

rs.Open "SELECT * FROM table WHERE phone ='" & request.form("phone") & "'"

the extra ampersand is making it go into concation mode.  So I guess the
real question is how to escape the ampersand.  I couldn't find anything on
escaping characters with ASP.

Thanks,
Josh