Ohhhh, I bet this is a CF 6.1 vs. 7 issue! Let me guess, you're all running 6.1?
Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patrick McElhaney Sent: Thursday, October 12, 2006 11:34 PM To: [email protected] Subject: Re: [Reactor for CF] Syntax error at token 0, line 0 offset 0 Okay, I think found a solution. A cfsavecontent in the renderSelect function of query.cfc seems to be flaking out. I replaced the cfsaveconent with a bunch of cfsets and that seems to have made the difference. Here's the code I changed. It's ugly and half-baked but I want to get this out in case anyone else is up late working on this problem. <cffunction name="renderSelect" access="public" hint="I render a select query" output="true" returntype="any" _returntype="string"> <cfargument name="Query" hint="I the query to render. " required="yes" type="any" _type="reactor.query.render.query" /> <cfargument name="Convention" hint="I am the Convention object to use when rendering the query." required="yes" type="any" _type="reactor.data.abstractConvention" /> <cfset var result = "xxxx" /> <cfset var where = arguments.Query.getWhere().getWhere() /> <cfset var order = arguments.Query.getOrder().getOrder() /> <cfset var whereNode = 0 /> <cfset var orderNode = 0 /> <cfset var x = 0 /> <cfset result= "SELECT "> <!--- distinct ---> <cfif arguments.Query.getDistinct()> <cfset result = result & "DISTINCT "> </cfif> <!--- collumns ---> <cfset result = result & "#arguments.Query.getSelectAsString(Convention)# FROM #arguments.Query.getFromAsString(Convention)# #renderWhere(arguments.Query, arguments.Convention)# "> <cfif ArrayLen(order)> <cfset result = result & "ORDER BY "> <!--- loop over all of the order-bys and render them out ---> <cfloop from="1" to="#ArrayLen(order)#" index="x"> <!--- get the arguments for this expression ---> <cfset orderNode = order[x] /> <!---#arguments.Convention.formatFieldName(orderNode.field, orderNode.object)#---> <cfset result = result & "#getFieldExpression(orderNode, arguments.Convention)# #UCASE(orderNode.direction)# "> <cfif x IS NOT ArrayLen(order)> <cfset result = result & ", "> </cfif> </cfloop> </cfif> <cftrace text="resultOfRenderSelect: #result#"> <cftrace text="getFromAsString: #arguments.Query.getFromAsString(Convention)#"> <!--- make this valid cfml ---> <cfset result = Replace(result, "[[", "<", "all") /> <cfset result = Replace(result, "]]", ">", "all") /> <!--- return the query ---> <cfreturn result /> </cffunction> Hope this helps. Patrick -- Patrick McElhaney 704.560.9117 -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
