[transfer-dev] [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near '.'

2009-01-20 Thread Jorge Loyo
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

[transfer-dev] Re: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near '.'

2009-01-20 Thread Bob Silverberg
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,

[transfer-dev] Re: how can i view the sql statement being executed?

2009-01-20 Thread Jared Rypka-Hauer
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...

[transfer-dev] Re: how can i view the sql statement being executed?

2009-01-20 Thread Bob Silverberg
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

[transfer-dev] Re: how can i view the sql statement being executed?

2009-01-20 Thread Doug Boude
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

[transfer-dev] Re: how can i view the sql statement being executed?

2009-01-20 Thread Mark Mandel
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

[transfer-dev] Re: Collection of top-level objects?

2009-01-20 Thread Mark Mandel
That is pretty much it. Transfer only allows retrieval of singular objects, due to performance concerns with getting large data sets as objects (CFC creation is still quite slow). That being said, it's something I've been thinking about a great deal, just not quite sure which approach to take

[transfer-dev] Rollback 'save()' methods using Transaction advise()?

2009-01-20 Thread bimp
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

[transfer-dev] Populating a New TransferObject

2009-01-20 Thread Jorge Loyo
I am new to transfer and I am having trouble with this. I am currently using Mach-II and the event-bean in an event- handler. If I submit a request to save a new user how can i use my event arguments to populate a transfer object that i can use to save the new record. thank you

[transfer-dev] Re: Rollback 'save()' methods using Transaction advise()?

2009-01-20 Thread Mark Mandel
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

[transfer-dev] Re: Populating a New TransferObject

2009-01-20 Thread Doug Boude
I'm not familiar enough with Mach II to tell you specifically, but I do know that most of the frameworks have a method available whose purpose in life is to take the incoming event arguments and automatically populate a bean. Model Glue has it's makeEventBean method, Coldbox has it's

[transfer-dev] Re: Rollback 'save()' methods using Transaction advise()?

2009-01-20 Thread bimp
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

[transfer-dev] Re: Rollback 'save()' methods using Transaction advise()?

2009-01-20 Thread bimp
Mark, Thanks again but one thing I noticed. The cftransaction action=rollback works in that the newly inserted test record doesn't appear post-test in my table. However the autoincrement ID field of that same table does actually increase in my SQL Server table. I confirmed this by first

[transfer-dev] Re: Rollback 'save()' methods using Transaction advise()?

2009-01-20 Thread Bob Silverberg
That is the nature of identity fields in SQL Server. There's nothing you can do about it (short of running a DBCC CHECKIDENT command, which you don't want to do), but it really should have no bearing on your application. You should not be counting on the value of your identity fields being in