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 ______________________________________________________________________ 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
