View Single Post
Old 06-05-2011, 01:34 AM   #1
Pluribus
Newly Registered User
 
Join Date: Dec 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Pluribus is on a distinguished road
Question Problem accessing certain records from access db using asp

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
Attached Files
File Type: zip products.asp.zip (439.7 KB, 202 views)

Pluribus is offline   Reply With Quote