[thelist] ASP - & Encoding

[Josh Nolan]

you can do it this way....

set the SQL to a varaible.

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

that is what i usaully do and it works out ok...

----- Original Message -----
From: "Feingold Josh S" <Josh.S.Feingold at irs.gov>
To: <thelist at lists.evolt.org>
Sent: Friday, March 22, 2002 11:03 AM
Subject: RE: [thelist] ASP - & Encoding


> 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
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>
>
>