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