Try <cfdump var="#getinfo#"> -----Original Message----- From: Jeff Becker [mailto:[email protected]] Sent: Thursday, December 11, 2008 4:12 PM To: cf-talk Subject: SmarterStats API
Hello everyone, I am having trouble with the SmarterStats API and utilizing ColdFusion to gather stats. I have successfully made the call and am getting the results back. However, I think because my return of complex type(??), I'm not sure how to interpret/display the results. Based on the minimal documentation, I was hoping to get back. QueryItem Visits id=123 89 id=124 52 id=125 5 The code I have is below. The cfdumps give back just ugly "object of com.smartertools.smarterstats.query.ExecuteQueryResponseExecuteQueryResu lt" OBJECTS.. not very useful. The attempt below is what I tried in traversing these objects. See code below. Any ideas? <cfset query="select * from ftopqueriesbypage(1,'2008-09-08T00:00:00','2008-09-09T00:00:00',20,'/vie wArticle.cfm') order by Visits desc"> <cfinvoke webservice ="http://MYSITE.com:9999/services/query.asmx?wsdl"; method ="ExecuteQuery" returnVariable = "getinfo" > <cfinvokeargument name="authUserName" value="USERNAME"/> <cfinvokeargument name="authPassword" value="PASSWORD"/> <cfinvokeargument name="AuthorizationCode" value="WEBSERVICES_AUTH_CODE"/> <cfinvokeargument name="SiteID" value="1"/> <cfinvokeargument name="query" value="#query#"/> </cfinvoke> <!---<cfdump var="#getinfo#">---> <cfset a = getinfo.get_any()> <!---<cfdump var="#a#"---> <cfloop index="x" from="1" to="#arrayLen(a)#"> <cfoutput>#x# - #a[x].toString()# - - <BR><BR></cfoutput> </cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
