There are some users on this list, I believe, who have written tools that do all of this for you, including the query and proc params....
Bueller? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marlon Moyer Sent: Friday, July 15, 2005 3:27 PM To: [email protected] Subject: Re: [CFCDev] One DAO for each dBase table? It shouldn't be too hard to do the same for Storedprocs since you can right click on the proc name and script the execute statement also. On 7/15/05, Marlon Moyer <[EMAIL PROTECTED]> wrote: > 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." > -- 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] ---------------------------------------------------------- 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]
