Re: [CFCDev] suggestions for DAO generators for CF (was MyGeneration: CodeGeneration Tool)

[Callum McGillivray]

Hi Barry, Pete, Have you seen this one ? http://www.franciswscott.com/downloads/cfccreator.zip Cheers, Callum Barry Beattie wrote: '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 cfcdev@cfczone.org 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/cfcdev@cfczone.org ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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/cfcdev@cfczone.org ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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/cfcdev@cfczone.org