Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 12th, 2004, 02:22 PM
Registered User
Join Date: Jul 2004
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default formatting a classifieds section. Part 2

i have a database table with a foreign key reference from another table. Which is the Markets table.

I now have a products column. As below

      Market Products descriptions
  Electronics sonyJ70 2003 sony mobile phone
  Electronics Binatone 3000 Binatone toaster
 Computers Dell navasion300 Dell desktops


i created a repeated region on my site. So all Markets would be repeated.
e.g you have

Bargains & Sales
Books & Magazines
Clothing, Accessories & Shoes
Flowers & Gifts

now i want to be able to select the total number of products from the table and have them inserted into the repeated region of the markets area. to have

Accessories, Parts, Tires, More...

Bargains & Sales
Free Shipping, Clothing Bargains, More...

Books & Magazines
New Books, Top Books, Book Releases, More...

Clothing, Accessories & Shoes
Women, Men, Shoes, Handbags, Lingerie, More...

Laptops, Desktops, Software, PDAs, More...

Digital Cameras, TVs, Cell Phones, More...

Flowers & Gifts
Birthday Flowers, Gift Baskets, Roses, More...


the script above would be database values, with repeated regions such as

categories, More....

to give the above results as seen on http://shopping.yahoo.com

How do i go about this ? I am made to understand that i use ASP scripts to loop through the query results to format the page as above

Thank you


Old August 13th, 2004, 04:40 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

Hi there,

Looks like cross-posting this. formatting a classifieds section

You could always continue with your previous post if that is of same topic, rather than posting it as a new thread.


- Vijay G
Strive for Perfection

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a CDATA section; add nodeset to CDATA section kssudhish XSLT 3 January 3rd, 2008 07:13 AM
Section formatting cankalu Crystal Reports 1 May 31st, 2004 07:28 PM
Formatting Report Detail Section rickf Access 3 February 3rd, 2004 07:15 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.