That would definitely be a two-tiered system. With all of your business logic in the database, I'm not sure how well that would scale. If all your database did was save and retrieve data, it would be easier to accommodate more users by simple adding some more web servers, but if your database starts getting bogged down because it is taking on the work of two tiers that would be harder to remedy I would think.
~Brad -----Original Message----- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 2:57 PM To: CF-Talk Subject: ColdFusion as presentation engine and nothing more I am wondering whatever anyone seen/ has opinion about the following system: All information that is presented on a HTML form to end user is build with information supplied by SQL Server stored procedure. I mean the data that makes the form + information how form should look like - information whatever a checkbox should be used or a text field + any special HTML formatting. All that CF does is: parse the result of stored procedure call and build HTML form based on data provided by stored proc. The CF components can dynamically build any form based on data from SQL server. CF is used as a page formatting engine - it formats data provided to it into visually pleasant form. On SQL server there are 1000's of stored procedures which are used to display form, validate, update, delete etc. Essentialy the form building is done on SQL server without even looking at any CF code. CF is a black box which rarely changes while 99% of development is in pure T-SQL (All developers are SQL experts while most don't know what CF is). TK ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:252097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
