I don't use stored procs, but what I've done is create cfm templates where I can paste an insert query or an update query from query analyzer (right click on table name and select 'Script object to Clipboard as -> Insert) into a textbox and then CF will generate a CF query with all of the queryparam statements with the correct attributes (maxlength,null,etc). Then I can just paste that into my dao's.
On 7/15/05, Peter H <[EMAIL PROTECTED]> wrote: > I just built a whole raft of DAO's using stored procs and it works well. > There were a couple of downsides though. > > 1) It's tedious. Writing the dao and setting up the method signatures and > <cfprocparam> list was very boring and I ended up switching between CF and > Enterprise Manager more times than I care to mention. > > 2) Changes to stored proc signature can get out of step with your CF code so > you have to be methodical when you do make changes. > > When I was building the DAO's I kept thinking wouldn't it be nice if I could > 1) autogenerate all these stored proc daos and 2) have a magic synchornise > button that would ensure my DAO's and database were in sync. So for my next > project that's what I'll be doing. > > Anyway, just my experiences and I'm sure there are better ways to approach > it than the way I did it. > > Cheers, Pete (aka lad4bear) > > > -- Marlon "But I'm near the end and I just ain't got the time And I'm wasted and I can't find my way home." ---------------------------------------------------------- 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]
