%|-}
----- Original Message -----
From: "Pascal Peters" <[EMAIL PROTECTED]>
Date: Sat, 12 Jun 2004 09:10:24 +0200
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: Grouping records
SELECT ...
FROM ...
WHERE ...
ORDER BY Company, FormsType, FormsDescr, Dept
<cfoutput ... group="Company">
#q.Company#
<cfoutput group="FormsType">
#q.FormsType#
<cfoutput group="FormsDescr">
#q.FormsDescr#
<cfoutput>
#q.Dept#
> -----Original Message-----
> From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
> Sent: zaterdag 12 juni 2004 2:12
> To: CF-Talk
> Subject: Grouping records
>
> Hi all
>
> please give me a little time. Help me to group this records...
>
> Company Dept FormsID FormsType FormsDescr
> Coca-Cola Co. Accounting 05D6EDD0-795D Contact
> Evaluation Testing Evaluation
> Coca-Cola Co. Administration 05D6EDD0-795D Contact
> Evaluation Testing Evaluation
> Coca-Cola Co. Administration 05D6EDD0-795D Contact
> Evaluation Testing forms
> Coca-Cola Co. Accounting 05D6EDD0-795D Contact
> Evaluation Testing forms
> Coca-Cola Co. Administration FFF0A8A0-795D Managers
> Evaluation Testing Evaluation
> Coca-Cola Co. Finances FFF0A8A0-795D Managers
> Evaluation Testing Evaluation
> Coca-Cola Co. Accounting FFF0A8A0-795D Managers
> Evaluation Testing Evaluation
> Coca-Cola Co. Administration FFF0A8A0-795D Managers
> Evaluation Testing forms
> Coca-Cola Co. Accounting FFF0A8A0-795D Managers
> Evaluation Testing forms
> Coca-Cola Co. Finances FFF0A8A0-795D Managers
> Evaluation Testing forms
>
>
> The correct is:
>
> Coca-Cola Co.
> Managers Evaluation Testing Evaluation Administration
> Accounting
> Finances
> Contact Evaluation Testing forms Administration
> Accounting
>
>
> How to aggregate my records? Thanx in advance... for any
> help... and for your time.
> --
> ___________________________________________________________
> Sign-up for Ads Free at Mail.com
> http://promo.mail.com/adsfreejump.htm
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
