Transfer ORM Like comparison

If you start using Transfer ORMenough you will start finding situations where you need to write some SQL. I know you thought the Transfer (or any ORM for that matter - CF9) would be the end of writing SQL. Well its not in fact when you do have to write some, it's not all that bad. Tonight I was writing a search feature for my shopping cart application when I realized I have never done a like comparison in TQL. It turns out its really no different than any other TQL I have written before.

If you take a look at the Transfer docs for Retrieving query lists you will not a listByQuery method. This method allows you create a transfer query and return the results based on it. This is important to note because its not a query object or some sql that you wrote, its a transfer query. If your not familiar with transfer queries or TQL I suggest you read up on them.

[More]

My Transfer 101 Presentation Code

I uploaded my presentation to SlidSix last week and also embedded it on this blog post. If you were at the presentation you know that I had a ton of code samples that I showed off. If you were not there I basically created a small eCommerce application using transfer. This is far from full featured and far from finished but its a start. I plan on continuing with this code and actually I might start 2 versions of the code, 1 with Transfer and 1 with Hibernate (CF9). Anyways the point of this post is that a couple people have asked me where they can download that code. If you visit The blog post with the presentation embedded or the presentation on SlidSix you can get it. All you have to do is click on the menu button and select download attachment. This will be the same for all presentations uploaded to SlideSix

Learn Transfer from a Jedi

If you have not heard of Transfer or had a chance to take it for a test drive I have found another great resource for you. First off Transfer is a ColdFusion Object Relational Mapping (ORM) Library. The main focus of the library is to automate the repetitive tasks of creating the SQL and custom CFCs that are often required when developing a ColdFusion application. I have downloaded the framework before but because of other things going on I never really used it. This weekend I had the chance to use it in a real application and found a real good resource.

If you are just starting out you really need check Ray Camden's tutorials. He takes you through setting up the framework and shows some basic concepts. Ray while being an extremely smart (and humble) guy has a great way of explaining things for the rest of us. You can click here to the transfer articles he has written. If you have any questions about transfer shoot me an email. While I am pretty new to it I have a pretty good grasp on the basics already.