Always depend on who the contract is being done for though. Most of the places I have worked for always give us(the contractors) basically full access to the DB in development and no access to production except special cases where they give simple select access. I have done work for some government agencies that required all queries to be within SPs and would imagine other places have similar requirements.
On 8/27/06, Snake <[EMAIL PROTECTED]> wrote: > > While on that subject, a lot of people insist that everythig should be > done > with SP's wherever possible. > While this is indeed a good idea for long/complex queries that will see > vastly improved performance and speed, but I think it is wrong to do it > just > for the sake of it, and to put basic select or other small queries etc > into > SP's. > One of the primary reasons being that where contractors are involved, they > will often have access to the CFML only and not the database server, and > thus cannot access the stored proc, which can seriously slow down > development time while they wait for the DBA to send them a copy of the > SP, > and then change it, send it back to the DBA, wait for him to apply it etc. > Also it is in general a pain if you need to do quick fixes or updates on > code in general. Usually it is easy to gain access to the code via FTP > from > wherever you are as this is generally an open port, but not to the DB > server, as you will either need remote access to port 1433 or remote > desktop > access. neither of which may be obtained quickly or easily as they > should/would be blocked from the outside world via a firewall. > > Just my 2p > > Snake > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 27 August 2006 13:42 > To: CF-Talk > Subject: Re: Top 100 ColdFusion Programmers > > Again, and the point has been echoed by James, is that the all-rounder > should know both. > > I am not saying that SPs etc (not that has anything to do with you level > of > SQL per se) are what you should know, we all know that ColdFusion can do a > lot with loops and SQL but if you have no choice but to use SQL in a job, > you will be stuffed if all you know SELECT. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
