I got version 1.1
This is the SQL generated:
select user.userId, user.first_name, user.last_name, user.email,
user.password, user.dt_last_login, user.ip_last_login,
user.is_logged_in, user.is_active, user.user_id FROM _tbl_user user
WHERE user.user_id IS NOT NULL
The error trace includes the
Could it be that user is a reserved word in SQL? Try changing the
alias of your table to something else.
Bob
On Tue, Jan 20, 2009 at 11:38 AM, Jorge Loyo jorgel...@gmail.com wrote:
I got version 1.1
This is the SQL generated:
select user.userId, user.first_name, user.last_name,
Maybe I'll implement it... finding out that I wasn't the only one that
wants it was encouraging. It seems to me that this is a completely
reasonable use case for Transfer to provide itself... insisting that
people use CFs debug in order to troubleshoot Transfer isn't. That's
my opinion...
One can actually get at this information programmatically, so it
doesn't really need to be added into Transfer.
To get the info yourself, you can use a method on the query's
underlying coldfusion.sql.QueryTable object. Assuming the query
returned from Transfer is called myQuery, you can ask
Good info, Bob. Had I known that little trick yesterday, I never would have
asked that Transfer give it to me. :)
On Tue, Jan 20, 2009 at 4:42 PM, Bob Silverberg bob.silverb...@gmail.comwrote:
One can actually get at this information programmatically, so it
doesn't really need to be added
On Wed, Jan 21, 2009 at 9:27 AM, Jared Rypka-Hauer
armchairde...@gmail.com wrote:
Maybe I'll implement it... finding out that I wasn't the only one that
wants it was encouraging. It seems to me that this is a completely
reasonable use case for Transfer to provide itself...
Not to belabour a
I'm trying to devise a method of rolling back database operations in
Transfer for unit testing purposes. After reading about leveraging the
Transaction object advise() implementation (http://docs.transfer-
orm.com/wiki/Transactions_and_Transfer.cfm), I tried creating a
function called
This is a really good question!
I've done similar things in my unit tests, by cheating a little, and
it worked a charm.
I can't seem the find the code... but the basics went something like
this (written in gmail, so errors will happen):
cfcomponent extends=frameworkYouUse.TestCase
cfscript
Mark, sweet that worked!!
Now correct me if I'm wrong. With this type of implementation of
rolling back, this assumes that in addition to the test functions
being advised by the Transaction class, that all the functions being
tested in the service, gateway, and business objects need to also be