> DAO --> Call it a day.. Thats great but I still want to know how people are handling DAO/SQL code which was my original question. Java has numerous class generators for this purpose but I don't see much if anything for coldfusion. In my original post I suggested this was due to the ease of CFQuery but I still don't feel this takes away from the tedium of writing database access code. It's time consuming and boring..
I've gone for a very basic dynamic table access aproach and it saves loads of time but feels a bit dirty and reading the various ideas raised about DAO's and gateways left feeling somewhat of a noob. In an earlier post I said I avoided methods like: getAllActive() getByOwner( ownerID ) getAllPrecedingDate( date ) in favour of a generic select(condition) method. I say that just because it is much easier and faster to hack together because i'm a sole developer. Personally I'd rather have DAO classes with loads of methods as mentioned above, however.. writing all those tedious methods is a PITA and best done by a class generator as mentioned earlier. And it'd be nice if we had autocomplete/dropdown listing of methods when accessing a CFC's in dreamweaver or other favourite CFMX IDE (eg eclipse). Might already exist.. let me know ;) thanks folks, TiM ## ## ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
