GROUP_CONCAT works only for 4.1+ MySQL versions... http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Cheers Marco On Tue, 14 Dec 2004 22:25:14 -0400, Jamie Price <[EMAIL PROTECTED]> wrote: > >Jamie Price wrote: > > > > > >SELECT o.UserID, GROUP_CONCAT(o.CardID) > >FROM mycards t INNER JOIN mycards o ON t.cardid = o.cardid > >WHERE t.trade = 1 > > AND > > o.own = 1 > > AND > > t.UserID = <cfqueryparam value="#cUserID#" > >cfsqltype="cf_sql_integer"> > >GROUP BY o.UserID > > > >Jochem > > I tried replacing my 2nd query with that code (the qGetMatches query) and got > the following error: > > Error Executing Database Query. > Syntax error or access violation: You have an error in your SQL syntax. Check > the manual that corresponds to your MySQL server version for the right syntax > to use near '(o.CardID) FROM mycards t INNER JOIN mycards o ON t. > > The error occurred in C:\Websites\mtgotradingpos\traders\match3.cfm: line 43 > > 41 : o.own = 1 > 42 : AND > 43 : t.UserID = <cfqueryparam value="#cUserID#" > cfsqltype="cf_sql_integer"> > 44 : GROUP BY o.UserID > 45 : </cfquery> > > Keep in mind I'm using MySQL v4.0.18 as my database solution - would your > code be compatible with that? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187707 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
