Jump to content

Display similar search results

Guest Petazaan

Recommended Posts

Guest Petazaan

Hi!Im working with an asp page (not written by me) for a company i sweden wich has a list of redistributors stored in an access database. My question is. When somebody searches for a distributor with a specific postal code. How do i write the code so that i displays the other distributors with similar postalcodes after the main results?This is my codeelseif request("update2")<>"" then search="SELECT tbRetailers.* FROM tbRetailers " search = search + "WHERE ((((tbRetailers.namn) Like '%"&Request("searchname")&"%') AND ((tbRetailers.ok)=true)) OR (((tbRetailers.ort) Like '%"&request("searchname")&"%') AND ((tbRetailers.ok)=true)) OR (((tbRetailers.postnr) Like '"&request("searchname")&"%') AND ((tbRetailers.ok)=true))) " search = search + "ORDER BY tbRetailers.postnr;" Set rsRetailers = cnn1.EXECUTE(search)end ifany suggestions would be nice :)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...