Re: [DFW CFUG] Repeatable Regions

Fri, 20 Jan 2006 10:07:19 -0800

And remember what ever field you want to GROUP by in the cfoutput tag needs to be in the ORDER BY statement in your SQL query.  In this case you would want to ORDER BY Vendor

On 1/20/06, Dave Shuck <[EMAIL PROTECTED]> wrote:
Actually that was regarding doing nested cfgrouping, but you should get what you need from that!

:)


On 1/20/06, Dave Shuck <[EMAIL PROTECTED]> wrote:
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



--
~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/





--
Ryan Everhart
[EMAIL PROTECTED] 
_______________________________________________
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