Well, actually, Sybase has a List() function that works JUST the way I
wanted. Unfortunately, SQL7 doesn't.
Grr. Grr, I say.
FYI, I hacked up a workaround in CF... not as pretty but it works.
Hmm... now if we were running CF5, I could probably use the 'query a query'
functionality to do what I wanted at that point... but we're not running it
yet. Alas and alack!
-----Original Message-----
From: Dean H. Saxe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 2:02 PM
To: SQL
Subject: Re: Returning list of values as a single field
Scott,
That will not work in SQL.
SQL deals with sets of data, you are trying to aggregate a set of data into
a single column. The only way you will see such results is if you try to
denormalize your tables or if you write a stored procedure which takes the
result set that you don't want (the first one in your email) and loop
through it to generate the second result set. If that's your plan, why not
use CFOUTPUT with the group attribute on the user column?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
