Problem accessing certain records from access db using asp

[pluribus]

Hi all

I am having a problem with an access database and was wondering if anyone could shed some light on it for me?

I have an asp page that serves content from an access database, depending on the variables added to the url - for example:

products.asp?pl=gardenmowers shows everything in the gardenmowers category, products.asp?pl=handtools shows the handtools etc.

Unfortunately for me, it is being very selective in what it wants to show. All the records are in the same table and the same products.asp page is used to serve all the content to the user. I have checked spellings, formatting etc but that is not the problem. In some instances I get a 404, others get a 500.

I cant understand what is causing the problem and I have been tearing my hair out for about a week trying to figure it out.

I have uploaded the database and the products.asp page in the attached zip file. I would appreciate it if someone could take a look and tell me where I have gone wrong.

Thanks

Ian

[Gunner]

I would Declare the variables first and see if that takes care of it.

Dim pro_type, pro_type1

pro_type = ""
pro_type1=""

pro_type = lcase(request.querystring("pl"))

select case pro_type
case "professionalmowers"
pro_type1="Professional Mowers"

etc....