Hi,
 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...

"select * from booktab where (booknmae like '%" & bname & "%')"

It should look something like that. bname should be a variable coming in from a user's interaction with the page.

Hi,
 Thanx for ur help.The error was 'Syntax error in select statement'.I cjanged the select statement as suggested by u.Now it's working fine.
  Thanx once again
     Sumesh