RE: CFLOOP has me stumped again.

2000-11-14 Thread George Cusumano
ancapid# > > > > > > > > > > > > > > > > > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On > > > Behalf Of Michael Kear > > >

RE: CFLOOP has me stumped again.

2000-11-13 Thread Michael Kear
OTECTED] [mailto:[EMAIL PROTECTED]]On > > Behalf Of Michael Kear > > Sent: Monday, November 13, 2000 6:54 PM > > To: CF-Talk > > Subject: RE: CFLOOP has me stumped again. > > > > > > Thanks a lot to Rick and Jaime, but I'm not quite there yet. I wa

RE: CFLOOP has me stumped again.

2000-11-13 Thread Jaime Garza
- #ancapid# > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Michael Kear > Sent: Monday, November 13, 2000 6:54 PM > To: CF-Talk > Subject: RE: CFLOOP has me stumped again. > > > Thanks a lot to Rick a

RE: CFLOOP has me stumped again.

2000-11-13 Thread Michael Kear
Thanks a lot to Rick and Jaime, but I'm not quite there yet. I was right about being so close to the trees I couldn't see the wood. I had forgotten about the 'group' attribute of CFOUTPUT tags. However using every combination I can think of, the best I can get is: Make1 model1 Make1 model2 Mak

RE: CFLOOP has me stumped again.

2000-11-13 Thread Rick Lamb
First off, there is no point in grouping your sql query by all the fields. This does nothing, and remember that there is a very big difference when you use grouping in sql then when you use grouping in cold fusion. I'll let you look into the sql group, but here is how i would use a cold fusion gro

RE: CFLOOP has me stumped again.

2000-11-13 Thread Jaime Garza
How about removing the GROUP BY and using ? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Michael Kear > Sent: Monday, November 13, 2000 5:37 PM > To: CF-Talk > Subject: CFLOOP has me stumped again. > > > I'm sorry if this is a very elementary C