The problem is the application was originally developed like 5 years ago and then upgraded along - I only came along few days ago - thus I am definitely not part of the "original team".
If you thought the app you are working on is tough to debug, think of me - we can always change places :) TK ----- Original Message ----- From: "Snake" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, September 05, 2006 5:33 PM Subject: RE: ColdFusion as presentation engine and nothing more > Lets hope no-one outside your original team ever has to work on this > application. > > Snake > > -----Original Message----- > From: Tom Kitta [mailto:[EMAIL PROTECTED] > Sent: 05 September 2006 21:17 > 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:252118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
