Maureen,
the GROUP BY clause will actually turn the non-GROUPedBY records into a
comma-delimited list? I sure cannot see how
what I want for an end result is 3 rows of data in the final recordset:
UserID ServiceIDs
1 "402,417,533"
2 "200,201"
3 {null}
(obviously I don't need the quotation marks, I'm just trying to show that
only 3 rows should be returned in the end)
----- Original Message -----
From: "Maureen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 1:34 AM
Subject: Re: brain fart: some simple SQL
> At 01:20 AM 11/29/01 -0500, you wrote:
>
> >Yeah, it's easy, but inefficient, to do with CF but how can I make SQL do
> >this for me (esp with the {null})? It's gonna turn out to be something
easy
> >that I've seen before, but I haven't had to write something like this for
> >like a year and now I'm drawing a one in the morning blank. Is it a GROUP
BY
> >thing? or a sub-query thing?
>
> Use the group by command.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
