's funny that Peter brought this up I'm looking for a DAO generator for CF at the moment.
the trouble is, I know exactly what I want but can't find the right one. Can anyone suggest a DAO generator? - MUST support Informix databases (v 9.4) (and eventually SQLServer, but that's later next year) - ability to specifiy which tables to create the CRUD routines against (either single or a list - NOT generate all 800+ tables we use in one go) - NOT NULL fields translated to <cfargument...required="true" /> - NULL fields translated to <cfqueryparam...null="#not YesNoFormat(len(argument.value)#" or similar plus the usual of getting the datatypes correct with cfsqltype, based on the schema, etc. and preferably source supplied so it can be tweeked (ie: for us "record_id" is a serial/identity field can be selected but is NOT part of the DML routines so it gets left out of the insert, update, delete methods*) any suggestions? thanx barry.b *madness? no...it's a legacy system. PKeys are concatenated from many fields and are really unique indexes. On 9/22/05, Peter Hardy <[EMAIL PROTECTED]> wrote: > Hi guys, > > Just stumbled across a code generation tool which looks pretty impressive. I > didn't write it (so have no vested interest in it) but it does look > promising. It can connect to lots of different databases and allows you to > write your code gneration templates in JScript, VBScript, C# or VB.Net. It > also allows you to provide a GUI for your template. It comes with a load of > pre-built templates but alas none for coldfusion. However, you can post > templates you write for other to download. > > Anyway, just thought I'd mention it cos it's free and it looks like it might > save hours of bean / dao / gateway / stored proc etc writing. And what the > heck, it beats writing your own generator :) > > You can take a look at > http://www.mygenerationsoftware.com/portal/default.aspx > > Cheers, Pete (aka lad4bear) > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > CFCDev is supported by New Atlanta, makers of BlueDragon > http://www.newatlanta.com/products/bluedragon/index.cfm > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
