[thelist] ASP - & Encoding

Chris Blessing webguy at mail.rit.edu
Fri Mar 22 13:08:25 CST 2002


If you're comparing against a character field, you may be able to use
regular quotes ("AT&T") instead of single quotes.  Try that.  What DBMS are
you using?

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> > 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




More information about the thelist mailing list