Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Sep 2004
    Location
    Louisville, Kentucky, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Single Record Web Page from Access Database

    I have a web page that shows all records from an Access database query. In each record, I have a thumbnail size picture my product that is a link to a larger version of the picture. Instead of showing just the larger picture, I need to show a page with product information and picture. How can I do this without creating individual pages for each product?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Single Record Web Page from Access Database

    <P ID="edit" class=small>(Edited by jscher2000 on 08-Dec-07 14:33. )</P>The most typical way to do this would be to use a server-side scripting language such as PHP or ASP. You can change you link to something like:
    <UL><code>[img]productImage.jpg[/img]</code>[/list]Then in your prodinfo.asp page, you select from the database for productCode. It is important to validate that code before sending it to your database so the user cannot retrieve the entire database or unexpected fields using "SQL injection".

    Added: I started a little project with a similar design. It involves See's candy and you can view a sample page here: http://sees.jeffersonscher.com/candy.asp?asst=tr1lb. Actually, the design on that page is a little counterintuitive. Clicking images enlarges them, while clicking product names shows the product information page. Someday (??!!) I will get back to this project. Perhaps around Valentine's Day. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  3. #3
    Lounger
    Join Date
    Sep 2004
    Location
    Louisville, Kentucky, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Single Record Web Page from Access Database

    Thanks for your reply. How do I get the "n=productcode" into the query to set up the page? I am very new to .asp and am using Frontpage database results wizard to make my original page.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Single Record Web Page from Access Database

    <hr>How do I get the "n=productcode" into the query to set up the page?I am very new to .asp and am using Frontpage database results wizard to make my original page.<hr>
    I haven't used the database wizard since FrontPage 2000, so my memory is a little vague. Actually, I think it's gone, sorry.

Posting Permissions

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