Ok, because this is in an OO query in a gateway I suspect it's somehow related to something I've done.
Please keep me posted. Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Byron Raines Sent: Wednesday, October 11, 2006 4:58 PM To: [email protected] Subject: Re: [Reactor for CF] Syntax error at token 0, line 0 offset 0 Weird is only the half of it. Now I'm getting really inconsistent results. Sometimes it is working, sometimes not. I will try to start from the beginning so I can document exactly what I've done. I'm also going to go back to an earlier revision to see if I've done something else. Byron Doug Hughes wrote: > My thoughts: That's Weird. With a capital W. > > What happens if you set the column to have a lower case l? As in lastname. > > Doug > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Byron Raines > Sent: Wednesday, October 11, 2006 4:09 PM > To: [email protected] > Subject: Re: [Reactor for CF] Syntax error at token 0, line 0 offset 0 > > Doug, > I think it may have found something. I have a column "Lastname" > in tblLeaveUser. I get the error if I try to sort by "Lastname" as in: > > <cfset variables.userGateway = > application.Reactor.createGateway("tblLeaveUser") /> > <cfset qryGetAllUsers = variables.userGateway.getAll("Lastname") /> > > I get the error. I do not get the error if I sort by any other column > in the table. So, I decided to change the name of the variable to > "Lastname1". Everything worked. So I changed name back to "Lastname". > I get the error again. > > Any thoughts? > > Byron > > > Doug Hughes wrote: > >> Can you send some sample code (without any fusebox dependencies - just a >> small script) that produces the problem? >> >> Doug >> >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >> Behalf Of Byron Raines >> Sent: Wednesday, October 11, 2006 3:21 PM >> To: [email protected] >> Subject: Re: [Reactor for CF] Syntax error at token 0, line 0 offset 0 >> >> Doug, >> >> I've deleted the \Reactor\project directory and still no dice. Also, >> under Exceptions in the debug info I get the following: >> >> *Exceptions* >> 15:10:26.026 - MissingInclude Exception - in >> D:\Inetpub\wwwroot\fusebox5\fusebox5.cfm : line 113 >> >> Could not find the included template >> ../Leave06/fusebox.appinit.cfm. >> >> >> 15:10:26.026 - java.lang.NullPointerException - in >> D:\Inetpub\wwwroot\Reactor\core\objectFactory.cfc : line 87 >> 15:10:27.027 - java.lang.NullPointerException - in >> D:\Inetpub\wwwroot\Reactor\core\objectFactory.cfc : line 87 >> 15:10:27.027 - java.lang.NullPointerException - in >> D:\Inetpub\wwwroot\Reactor\core\objectFactory.cfc : line 87 >> 15:10:27.027 - java.lang.NullPointerException - in >> D:\Inetpub\wwwroot\Reactor\core\objectFactory.cfc : line 87 >> 15:10:28.028 - Database Exception - in >> D:\Inetpub\wwwroot\Reactor\base\abstractGateway.cfc : line 92 >> >> Error Executing Database Query. >> >> >> 15:10:28.028 - Database Exception - in >> D:\Inetpub\wwwroot\Reactor\base\abstractGateway.cfc : line 92 >> >> Error Executing Database Query. >> >> >> Byron >> >> Doug Hughes wrote: >> >> >>> Did you try deleting the project files? >>> >>> Doug >>> >>> -----Original Message----- >>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>> Behalf Of Byron Raines >>> Sent: Wednesday, October 11, 2006 2:02 PM >>> To: [email protected] >>> Subject: Re: [Reactor for CF] Syntax error at token 0, line 0 offset 0 >>> >>> I'm getting the same error. Here is my error message: >>> >>> Error Executing Database Query. >>> [Macromedia][SQLServer JDBC Driver]Syntax error at token 0, line 0 offset >>> >>> >> 0. >> >> >>> >>> The error occurred in >>> D:\Inetpub\wwwroot\Reactor\base\abstractGateway.cfc: line 92 >>> Called from >>> >>> >>> > D:\Inetpub\wwwroot\Reactor\project\Leave06\Gateway\tblLeaveUserGateway.cfc: > >> >> >>> line 85 >>> Called from >>> >>> >>> > D:\Inetpub\wwwroot\Reactor\project\Leave06\Gateway\tblLeaveUserGateway.cfc: > >> >> >>> line 9 >>> Called from D:\Inetpub\wwwroot\Leave06\parsed\admin.Home.cfm: line 14 >>> Called from D:\Inetpub\wwwroot\fusebox5\fusebox5.cfm: line 209 >>> Called from D:\Inetpub\wwwroot\Leave06\index.cfm: line 4 >>> Called from D:\Inetpub\wwwroot\Reactor\base\abstractGateway.cfc: line 92 >>> Called from >>> >>> >>> > D:\Inetpub\wwwroot\Reactor\project\Leave06\Gateway\tblLeaveUserGateway.cfc: > >> >> >>> line 85 >>> Called from >>> >>> >>> > D:\Inetpub\wwwroot\Reactor\project\Leave06\Gateway\tblLeaveUserGateway.cfc: > >> >> >>> line 9 >>> Called from D:\Inetpub\wwwroot\Leave06\parsed\admin.Home.cfm: line 14 >>> Called from D:\Inetpub\wwwroot\fusebox5\fusebox5.cfm: line 209 >>> Called from D:\Inetpub\wwwroot\Leave06\index.cfm: line 4 >>> >>> 90 : <cfinclude template="#pathToQuery#" /> >>> 91 : </cfsavecontent> >>> 92 : <cfoutput>#replaceNoCase(queryData.query, "''", "'", >>> "all")#</cfoutput> >>> 93 : </cfquery> >>> >>> I have restarted, using Revision 386., delete Reactor project files, and >>> FB5 parsed files. >>> >>> Any things I might be missing? >>> >>> Thanks >>> >>> Byron >>> >>> >>> Thomas Dehli wrote: >>> >>> >>> >>>> Think I copied the wrong Reactor folder... doh. >>>> >>>> Apologies... >>>> >>>> - Thomas >>>> >>>> -----Original Message----- >>>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>>> Behalf Of Thomas Dehli >>>> Sent: Tuesday, October 10, 2006 10:48 PM >>>> To: [email protected] >>>> Subject: [Reactor for CF] Syntax error at token 0, line 0 offset 0 >>>> >>>> I just did a SVN update using Tortoise for Reactor and code that was >>>> >>>> >>>> >>> working >>> >>> >>> >>>> in Fusebox 5 now gives me... >>>> >>>> [Macromedia][SQLServer JDBC Driver]Syntax error at token 0, line 0 >>>> > offset > >>>> >>>> >>>> >>> 0. >>> >>> >>> >>>> This is what was working before: >>>> <cfset thisProperty = >>>> application.Reactor.createRecord("Properties").load(propID=1) /> >>>> >>>> What's strange is that it still works outside of Fusebox. >>>> >>>> Please... does anyone have any ideas of what it might be? I've been >>>> >>>> >>>> >>> banging >>> >>> >>> >>>> my head on this one all night. >>>> >>>> I've already deleted reactor and reactordata, deleted all parsed FB >>>> >>>> >> files, >> >> >>>> and restarted the server (many times)... I've also stripped FB5 down to >>>> >>>> >>>> >>> the >>> >>> >>> >>>> bone... same error everytime. >>>> >>>> Thanks, >>>> Thomas >>>> >>>> >>>> >>>> >>>> _____ >>>> >>>> avast! Antivirus <http://www.avast.com> : Outbound message clean. >>>> >>>> >>>> Virus Database (VPS): 0641-1, 10/10/2006 >>>> Tested on: 10/10/2006 10:47:48 PM >>>> avast! - copyright (c) 1988-2006 ALWIL Software. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >>>> >>>> >> -- >> >> >>>> -- -- >>>> Reactor for ColdFusion Mailing List >>>> [email protected] >>>> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ >>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >>>> >>>> >> -- >> >> >>>> -- -- >>>> >>>> >>>> >>>> >>>> _____ >>>> >>>> avast! Antivirus <http://www.avast.com> : Outbound message clean. >>>> >>>> >>>> Virus Database (VPS): 0641-1, 10/10/2006 >>>> Tested on: 10/10/2006 10:52:52 PM >>>> avast! - copyright (c) 1988-2006 ALWIL Software. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >>>> >>>> >> -- >> >> >>>> >>>> >>>> >>> -- -- >>> >>> >>> >>>> 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/ >>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >>> > -- > >>> -- -- >>> >>> >>> >>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >>> > -- > >>> >>> >> -- -- >> >> >>> 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/ >> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >> -- -- >> >> >> >> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >> > -- -- > >> 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/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
