If you are using Windows and SQL Server, Plum will do this for you. The IDE (code gen) contains options for generating CRUD SPs per table and will also generate a CFC that calls them. I haven't been using SPs as of late, but it worked well with MS SQL 2000. I would think they would work with MS SQL 2005, but can't say for sure.
http://www.productivityenhancement.com/plum/ HTH On 10/24/06, Brian Peddle <[EMAIL PROTECTED]> wrote: > > I have worked a few companies where they use .NET and know of several > other companies who follow this process. They have a generator that > reads all the stored procs and creates the needed code in .NET to make > the calls to the stored procedures in classes. All this is done > automatically and the file is never edited by human hands. One of the > cool things is that if a stored proc is altered and the file is > recreated on build any page calling that class will fail and they can > quickly and easily see what needs to be fixed. The other cool thing is > all the SQL is in one place. > > Anyway, has anyone ever done this in CF? Not so much the auto generate > stuff (although be good to know) but have one monster .cfc with all the > calls. Since it isn't compiled like .NET performance may be a huge > issue but not sure. Or maybe if this is tossed in application scope it > would fly. > > Thoughts? > > Hope this made sense. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4