SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Nov 2010
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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 Attached Files

  2. #2
    SitePoint Zealot
    Join Date
    Aug 2003
    Location
    Land of 10k Lakes
    Posts
    161
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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....


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •