RE: [DFW CFUG] Repeatable Regions

Fri, 20 Jan 2006 11:25:35 -0800

Dave and Ryan,
 
Thanks,  that was a help.
 
Mike Sumner
Nations Best Sports
817-788-0034 ext 244
817-788-8542 Fax
 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Shuck
Sent: Friday, January 20, 2006 11:58 AM
To: Dallas/Fort Worth ColdFusion User Group Mailing List
Subject: Re: [DFW CFUG] Repeatable Regions

What you are looking for is using the "group" attribute of cfoutput.  I wrote a blog entry on this sometime back.  Go take a look at this:

http://www.daveshuck.com/index.cfm?commentID=23


On 1/20/06, Mike Sumner <[EMAIL PROTECTED]> wrote:
This is my first post so be gentle.
 
I am trying to display all records from one table with matching records from another.  I joined the table and get all matching records.  What I have works except that it repeats the information from the first table for each record in the second. Something like this:
 
Vendor: 10X
Item: 123
 
Vendor 10X
Item:  124
 
Vendor Remington
Item: 870
 
Vendor Remington
Item: 870 Express
....
 
would Like to get something like this
 
 
Vendor 10X
Items: 123
Items: 124
 
Vendor Remington
Item:  870
Item: 870 Express
 
 
I have another page that pulls just one record form the Vendor Table and all the Items for that vendor to view one record at a time.  Which is one path that works.
 
Here is the page - again be gentle - I am going to use cfdocument and output to PDF, and I did try to limit the records with the function in the Repeatable region wizard but it did not work so it will take some time to load.  
 
I would appreciate any help.
 
 
 
Thank you,
 
 
 
Mike Sumner
Nations Best Sports
817-788-0034 ext 244
817-788-8542 Fax
 

_______________________________________________
Reply to DFWCFUG:
 [email protected]
Subscribe/Unsubscribe:
 http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
    http://www.mail-archive.com/list%40list.dfwcfug.org/
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
 www.HostMySite.com
  www.teksystems.com/





--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com 
_______________________________________________
Reply to DFWCFUG: 
  [email protected]
Subscribe/Unsubscribe: 
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
    http://www.mail-archive.com/list%40list.dfwcfug.org/             
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
  www.HostMySite.com 
  www.teksystems.com/

Reply via email to