Right...well you will have to do this in Cold fusion if you want it as a list. Keep your SELECT query the same except you need to ORDER BY username. Then in CF do the following:
<cfoutput query="<query name>" group="username"> #username# <cfoutput>#groupname#,</cfoutput> </cfoutput> -----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 13 February 2002 12:14 To: SQL Subject: RE: Is it possible? That was example data... Currently it returns to rows as described below, the username and groupname which in this case just happens to be groupname. But I was hoping the query would return one row like this Username, Groupname Andrewcs group1,group2 I guess my query is a little ambitious, the problem is that this query isn't necessarily a CF query as I would like to use it in all apps -----Original Message----- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 13 February 2002 11:09 PM To: SQL Subject: RE: Is it possible? Sorry I don't know what you mean by group name in a list. You will either need to use distinct, group by, or use the group by in ColdFusion when you use your outout tag. Not sure which is appropriate until you explain what you want the output to look like. Perhaps some example data may help -----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 13 February 2002 11:59 To: SQL Subject: Is it possible? Is it possible to be able to do the following, currently it returns a row for each record. Row_Return andrewcs groupname andrewcs groupname What I was hoping for is that it returned one row, but with the groupname in a list. Am I being too ambitious with my query! Here is the query SELECT og_Users.u_Username, og_GroupName.gn_Name FROM og_Users INNER JOIN og_UserGroup ON og_Users.u_ID = og_UserGroup.u_ID INNER JOIN og_GroupName ON og_UserGroup.gn_ID = og_GroupName.gn_ID ______________________________________________________________________ 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
