DataFaucet on ColdFusion9

[Ryan McIlmoyl]

After upgrading to ColdFusion9, DataFaucet does not run. The issue
seems to be the use of a local variable named 'local' in /system/agent/
sqlagent.cfc. My guess is this is conflicting with the new 'local'
scope. Renaming this variable cleared up all the errors I was
experiencing. Has anyone else experienced the same thing?

[Ryan McIlmoyl]

A further note on this problem. Changing the name has corrected the
exception, but now my select statements are broken. It seems to be a
problem with filters, I've dumped the .getProperties() function from
my statement object, and the sqlparameters array is full of empty
strings. I'm still digging to see if I can figure out what's going on
there. Again, if anyone else has tried on ColdFusion9 and run into
problems like this (or hasn't) I would greatly appreciate any
additional data.

[Isaac Dealey]

Thanks for the heads up, Ryan. :)

I haven't installed CF9 yet. It looks like I've got a lot of work to do
though... I've got a slew of functions in the onTap framework that use a
var'ed structure named "local" that I'll have to update. And although
I'm always hopeful that upgrades will be as neat and seemless as they
were from CF7 to CF8, where I didn't have to do anything at all (at
least not that I can remember), of course that can't always be the case.
:) I think we still need some work to get DF working on Railo or BD as
well.

And actually after looking at my development copy of DataFaucet I
realize that there are a number of references to "variables.local" in
the duck.cfc that came to DF from the onTap framework, and that's
*probably* causing some problems and I would guess is at the root of a
lot of the issues you're running into. The good news here is that
variables.local is only directly referenced in a couple of places
(notably in the getProperty/setProperty methods), so it shouldn't be too
difficult to fix. :)

Anyway, the note about the local scope will be really helpful to us, so
thanks for sharing that, and I look forward to hearing anything else you
find. :)

--
[ ike ] founder - DataFaucet ORM

phone: 781.769.0723

http://www.datafaucet.com

[Isaac Dealey]

I started working on the "local" issue and I realized that there were a
lot of functions in DataFaucet that had a var'ed "local" structure in
them. And it didn't take too long to replace them, however, now I'm
running into some unexpected issues with my Members onTap plugin for the
onTap framework. I'll have to investigate further tomorrow. The maze
game is working perfectly (as far as I can tell) using the new
persistence service code with the updates for CF9, so I'm pretty sure
the issue I'm having is with an activerecord or gateway object. I
haven't submitted all the code to the SVN repository yet, I just wanted
to let you know that I'm working on it and I expect I'll have some new code
checked in tomorrow.

Thanks again, Ryan! :)

--
Isaac Dealey - AutLabs
Creating meaningful employment for people with Autism
http://www.autlabs.com

phone: 781.769.0723

http://www.datafaucet.com

[ike]

Hey Ryan, thanks for your help. I've just committed my changes to SVN,
removing all references to "local" in the DataFaucet core code. If you
can get the latest from SVN to test on your CF9 instance, that would
help us out a lot. Once we've got it reasonably working on CF9 then
I'll publish a new stable version of the release candidate.

[Ryan McIlmoyl]

Thanks Ike, that's great. I'll grab the latest from SVN and re-run my
tests, I'll let you know what I find. (I'm not doing anything overly
complex right now, we're abstracting some inserts and selects, as well
as the DDL).

[Ryan McIlmoyl]

My tests pass again, thanks Ike!!! In the future, feel free to enlist
my help for any other testing/debugging etc. I've been pretty happy
with DataFaucet so far, and don't mind putting in a bit of time to
help keep it going. Thanks again!

On Oct 17, 1:42 pm, ike <i...@turnkey.to> wrote:

[ike]

Spectacular! Thanks Ryan! :)

I'd also love to hear where and how you're using DataFaucet. Maybe we
could post a note about it on the DF blog or create a page on the
framework site for "Who's using DataFaucet". I know a lot of other
open source projects have a "who's using" page and I think they're
helpful in keeping projects active. :)

[Ryan McIlmoyl]

The project is still in development, so there's not a lot to say about
it yet :) When we have something out there, I'll be more than happy
to provide you with some details.

[Isaac Dealey]

> The project is still in development, so there's not a lot to say about
> it yet :) When we have something out there, I'll be more than happy
> to provide you with some details.

Ahh, the super-secret project. ;) I'll bet it's fun to work on!

Thanks Ryan, Looking forward to it. :)

--
Isaac Dealey - AutLabs

Creating meaingful employment for people with Autism