Well you could use the ValueList() function on your initial query... seeing
as you appear to want to restrict the query to a single ID, and all the
groups associated...
UserDetail.Group = ValueList(queryname.groupname)
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 5:34 AM
To: SQL
Subject: RE: Is it possible?
Yes that would work, but I am not wanting to output this data. How was
hoping to make the SQL do the work for me. So that I could create an
associate array so in CF it would be something like this
<cfscript>
UserDetail = StructNew();
UserDetail.UserID = u_ID
UserDetail.Username = u_Username
UserDetail.Group = (whatever in groups table as a list)
</cfscript>
I was hoping rather than 2 queries, I could do this with one. Any help
would be appreciated, but please don't put any urgency on it. I would
prefer the one query but can live with 2.
-----Original Message-----
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 13 February 2002 11:23 PM
To: SQL
Subject: RE: Is it possible?
Let us know if that solves your problem,
if not I'll see If I can get it to work in SQL for you.
J
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
