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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
