Hi People,

Having major trouble wondering if you can help. I have a search page with three text boxes, where i want the user to be able to search for albums in my database based on a combination of artist name, album name or genre(this is a drop down box) or all three if they want.

I've tried starting out simple and just done

strSQL="select * from albums"

If stralbumname<>"" Then
strSQL=strSQL + "where album_name like '%"& stralbumname &"%'"
End If

But it just wont work, instead i get a list of all the albums regardless of whether i type something in the text box or not.

Any ideas would be much apreciated thanks

Perhaps this may hopefully give you some ideas:

Classic ASP Design Tips - Search Criteria on Multiple Fields
http://www.bullschmidt.com/devtip-searchcriteria.asp

Hey

Thanks for the reply, article was really helpful and now my search facility works great!!

Thanks