problem in asp with select statement

plz solve it

[ankurdave]

i got the problem in select statement like that
when i write "SELECT * FROM abc where heading="'" & Request.form("headno") & "'"
then it not give the answer
what is the problem

[WebJoe]

Welcome to WebmasterWorld [webmasterworld.com]

What do you mean by

it not give the answer

just no records, or do you get an error?

Also, I think you either copied the statement wrong or there is an error. In your posted code, there is one quotation mark too many. The correct code should be:

"SELECT * FROM abc where heading='" & Request.form("headno") & "'" 

(note: no quotation mark after the equal sign)