ColdFusion RIA - SQL

ColdFusion 9's ORM Entity Load Functions

Wed, 22 Jul 2009 22:48:00 -0400

Update: Demo is currently unavailable.

This is a blog post, mainly so I have a good single place to refer the many varities of EntityLoad() functions available in ColdFusion 9. EntityLoad() is the main method you will be using to retreive objects for your persistent CFCs.

The Demo has eight different examples to accomplish various tasks through EntityLoad() function.

[More]

ColdFusion 9 cfgrid with ORM: Part 1

Tue, 21 Jul 2009 12:30:00 -0400

One of the exciting new feature in ColdFusion 9 is its ORM implementation. ORM in simplest terms allows us to access the database using objects, or in in even more simpler terms you don't have to write any queries for simple CRUD functions. To learn more about ColdFusion 9 ORM visit Adobe's ColdFusion 9 ORM Docs and Introducing ORM in ColdFusion 9 Beta.

This post will look at implementing a cfgrid using ORM. This will be first in a series starting from just implementing the grid to read data ending with a full fledged CRUD cfgrid with ORM.

[More]

Delete and Drop All Tables from SQL Server Database

Mon, 20 Jul 2009 02:01:00 -0400

This post is more for record keeping. Found this useful little SQL on another site and posting it here will make it accessible to me forever.

[More]