I'm continuing work on my Basecamp API integration and have a question. Basecamp returns XML, which I am converting into a query object in certain cases. My goal is to convert the XML returned by several methods into a query, which I can then join using query of queries. So I have two queries, one named projects and the other named times. I read online that query of queries appears to allow joins, but in practice (CF7) it doesn't seem to be working. My first question is can anyone confirm if QoQ allows joining? My second question is what's the syntax? Here's my SQL (pretty vanilla): <cfquery name="joinProjectsTime" dbtype="query"> SELECT * FROM timetracking INNER JOIN projecttracking ON projecttracking.id = timetracking.projectid </cfquery> Here's the error that I get when I run the above code (note that taking this cfquery tag out completely results in no errors): Query Of Queries syntax error. Encountered "INNER. The error occurred in C:\CFusionMX7\wwwroot\basecamp\index.cfm: line 9 7 : <cfset projecttracking = basecamp.xmlToQuery(projects.contents.xmlroot)> 8 : 9 : <cfquery name="joinProjectsTime" dbtype="query"> 10 : SELECT * 11 : FROM timetracking ____________________________________ Andy Matthews Senior Coldfusion Developer
Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com <http://www.dealerskins.com/> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
