triggermorf
New member
I have the following SQL statement "
searchRS = "Select * FROM staff where staffname like '%" & request.form("inputsearch") & "%' order by staffname" & request("order_var")" It is a search box on my website that displays whatever the user types in. The only problem is it displays everything instead of just what matches. I think it is the wildcards. When I try to remove them I just get some big long error because I don't think I am removing them correctly and keeping the correct format. So would someone please remove them for me but tell me how you did it because it is really starting to anoy me.
By displaying everything I mean it displays everything in the table from the access database instead of bringing up records that match what the user put in the search box.
searchRS = "Select * FROM staff where staffname like '%" & request.form("inputsearch") & "%' order by staffname" & request("order_var")" It is a search box on my website that displays whatever the user types in. The only problem is it displays everything instead of just what matches. I think it is the wildcards. When I try to remove them I just get some big long error because I don't think I am removing them correctly and keeping the correct format. So would someone please remove them for me but tell me how you did it because it is really starting to anoy me.
By displaying everything I mean it displays everything in the table from the access database instead of bringing up records that match what the user put in the search box.