use a DISTINCT clause in your SELECT statement. That way each product will
only have one record and the rest of the problem solves itself...
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 9:27 AM
To: CF-Talk
Subject: next previous with grouped output
Hello all,
I'm having a hard time wrapping my brain around doing a "next page" type
output where the query output is grouped.
Basically, the table has products made up of three records (each) that are
output as one. I wish the differences were simply attributes to I could
normalize the product table, but unfortunately, they need to be treated as
seperate products.
The number of records returned is NOT always going to be three times the
number of products listed. Sometimes each product will only have one record,
and sometimes up to three.
Any ideas??
Jeff Beer
Director of Application Development
Digital Stormfront, Inc
http://www.digitalstormfront.com <http://www.digitalstormfront.com>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
