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

Reply via email to