You can still do this by using the group attribute of the CFOUTPUT tag. Instead of outputting it to the screen you just set the element of the array= to the list that you have built up. This is the only way of using one query I think.....
-----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 13 February 2002 12:34 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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
