You are using SQL server? I'll check it out sometime this afternoon, of course another alternative is to write a stored proc. But in saying that the sql would remain pretty much the same.
would just run a lot quicker thats all. J -----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 12:34 PM 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
