I agree with everything that Dave says... (Having just deleted all the stuff I typed cos it was a repeat)
Only to add that.... > > eliminating unnecessary whitespace is important to me. But you will find > that there are some people who swear by using CFOUTPUT QUERY="". When it > comes to grouping and stuff, more often than not, I can take care of that in > my SQL statement. > Grouping with CFOUTPUT is so easy its ridiculous not to use and maybe marginally faster than your own grouping code. The SQL you create for a grouped CFOUTPUTs is the same as you would use for writing your own grouping in a CFLOOP. I've use both grouped cfoutputs and grouped cfloops. Really it just depends what I want to do with the data and the groups. (warning favourite phrase of the moment) Horses for courses. Choose the one that matches your needs best. Simple grouping, go for cfoutput, more complex stuff is probably better done with a cfloop. Regards Stephen ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
