[thelist] ASP - & Encoding

[darren]

On 22 March 2002 at 18:48:03, Feingold Josh S <Josh.S.Feingold at irs.gov> wrote:

FJS> The page should perform the following query:

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

is this a typo, or are you really trying to get the value from the form and
not the querystring??

you want to do a:

   Response.Write "SELECT * FROM table WHERE phone ='" & request.form("phone") & "'"

before you try and open a recordset with it.  make sure it contains the
values you want.

darren.