[cfaussie] Re: Someone help with this bit of code?

Mon, 04 Sep 2006 19:18:37 -0700

With the CFOUTPUT using group
you will only be looking at the first BO_ID - and I am guessing that there are  23 unique BO_IDs

if you want to process all of the records you either need an inner CFOUTPUT or loss the GROUP attribute.


On 9/5/06, Andrew Scott <[EMAIL PROTECTED]> wrote:

Dale,

Not my code, but before I clean it up properly I need to know why there is a
difference.

And even with the inner joins it still doesn't match the difference to using
the cfoutput group="", the code you posted Dale is the code I did write, and
it returned 73 records, as well as the code I posted 73 records. The
original query without the extra and the group attribute and with the cfif
and cfelse returnes 23 records.

And I don't understand what the difference is between doing it entirely in
the SQL and doing it via a group attribute on the cfoutput?


Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to