Skip to main content
Known Participant
October 9, 2008
Question

retrieve fields from a database

  • October 9, 2008
  • 2 replies
  • 346 views
Hello,

I am working on this page:
products new

This products have a category id in the database. My question is, how do I tell the webpage to retrieve only the products from the category id = "101" and so on. How can I pass that information so the page knows which products to put in the dynamic table?

In the old products.asp page this worked with this string in the url box:
http://www.chloecloset.com/products.asp?cat=98

the fields that my recordset have are:
pDescription, pID, pImage, pSection

I think pSection is equal to cat number

Please advice, I am attaching my code

Thanks
This topic has been closed for replies.

2 replies

Known Participant
October 9, 2008
thank you dooza!!!!!
Inspiring
October 9, 2008
I Love Doing Websites wrote:
> Hello,
>
> I am working on this page:
> http://www.chloecloset.com/products_new.asp
>
> This products have a category id in the database. My question is, how do I
> tell the webpage to retrieve only the products from the category id = "101" and
> so on. How can I pass that information so the page knows which products to put
> in the dynamic table?
>
> In the old products.asp page this worked with this string in the url box:
> http://www.chloecloset.com/products.asp?cat=98

You need to filter the recordset with the value from the querystring.

Dooza

--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html