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