So if you want to change the interface, you need to change the table structure? Wow...
And you're handling your form validations on the SQL end? I'm sure you could do it faster and better within CF. Cheers, !k -----Original Message----- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 2:17 PM To: CF-Talk Subject: Re: ColdFusion as presentation engine and nothing more The SQL server stored procedure returns: single row which is not HTML - CF builds HTML based on that single row result set. The data contained in SQL resultset has things like: 'User Name_txt50' - means display a field with caption 'User Name' that is a text field with 50 chars length. It can also return values that are interpreted as calls to additional stored procedures to be made by CF (i.e. SQL tells CF how to populate a dropdown by telling it: call this stored procedure to get your data). Another example, hidden form field such as userID would be passed with column name 'userID_hidden' and say a value of 23456. Form validation is done in SQL (except JS which can be given to CF from DB via initial "single data row") - CF just passes form scope to SQL server and SQL server either is OK with it or throws an error. Business rules are also in SQL - SQL server determines for example whatever to renew user subscription or not. TK ----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, September 05, 2006 4:10 PM Subject: RE: ColdFusion as presentation engine and nothing more >> I am wondering whatever anyone seen/ has opinion about the >> following system ... > > Does "yecch" count as an opinion? > > Seriously, though, what exactly is being returned by SQL Server? XML > documents? Recordsets? Strings containing HTML? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:252095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
