cause I was hoping to avoid 'that' extra layer - can't version easily , sprocs are different for each db.
Built a large project with 100 sprocs - had a generator that built a cftag (CF5) for each sproc (did parameter validation etc). Having to move out of homesite into query analyzer and remember whether I had recompiled after each update to the sproc definition was a pain, rebuild the tag etc. Sure some performance gains - especially because i could do 10 things at once with one sproc call like - approving the object, versioning and creating tasks etc etc. Maintenance is the real issue. Originally doid it on that project so asp or could be used to build the view/controller and leave the model in the db mostly. Elliot "Mark Mandel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > If you are going to all that trouble to 'move' the sql out of the CFC > - why not just use stored procs? > > Mark > > On Tue, 27 Jul 2004 10:17:28 +1000, Elliot Russo > <[EMAIL PROTECTED]> wrote: > > What are you thinking Peter? - just keeping sql in separate file to the cfc > > method body. > > > > Elliot Russo > > > > "Peter Tilbrook" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > > > > > > > Um that possibly opens up severe database security issues (if the XML > > > is tampered with). > > > > > > Why not let the DB server do the work as it is designed to? CF itself > > > is NOT a database server remember. > > > > > > > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com > ICQ: 3094740 > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
