problem in select statement in ASP-ACCESS
I am doing a bookstore application.When a particular language book(eg:java)is selected from the select box the ASP statement should fetch the corresponding results in to the recordset.
bname below is the bookname.
Set rs=conn.Execute("select * from booktab where booknmae like '%<%=bname%>%'")
on executing this asp page the error is shown with the code above.
Please help me out in this problem
Thanks in advance...