I'm not quite clear on this. Of course SP's aren't the only way of
separating business logic from presentation but aren't they one possible
means of doing so? SP's allow developers to abstract or separate server-side
functions from the client-side GUI. Multiple statements and conditional
logic can be processed within a procedure and simply exposed as a series of
values in and out. If only a tiny fraction of an application involves
Coldfusion and browser based technologies, moving any core DB functionality
on to a Coldfusion template mixes Business Logic with presentation to the
detriment of the app.
How else can core DB functionality be accessible to a dedicated Oracle
developer for example? This isn't always a requirement but it certain cases
it certainly is. Different projects have different requirements.
- Steve Barry
> -----Original Message-----
> From: Matt Liotta [mailto:[EMAIL PROTECTED]
> Sent: 24 March 2004 13:10
> To: CF-Talk
> Subject: Re: why are procedures better? (was: RE: Securing CF Apps.)
>
>
> The use of cfquery vs cfstoredproc has nothing to do with
> separation of
> presentation from business logic. You always want to do that
> and it can
> be achieved with both.
>
> -Matt
************************************************************************
Meteor web site http://www.meteor.ie
************************************************************************
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
