retrieve fields from a database

Forum|Forum|17 years ago
October 9, 2008
2 replies
349 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

Server side applications

This topic is closed to new replies. Start a new post to keep the conversation going.

I

I Love Doing WebsitesAuthor

Known Participant

thank you dooza!!!!!

N

Newsgroup_User

Inspiring

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.