Drop down list are handled rather with elegance (nothing complex is meant here by elegance) - SQL passes in the column name the caption and in the actual field value the name of the stored procedure that is used to populate the drop down.
TK ----- Original Message ----- From: "Jim Wright" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, September 05, 2006 4:59 PM Subject: Re: ColdFusion as presentation engine and nothing more > Tom Kitta wrote: > >> 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). >> > > Ow. I think I burst a blood vessel just thinking about trying to do > anything other than simple data validation in a SP. What happens if you > need to check for valid phone number format or valid email format? > Pattern matching is not one of SQL's strengths. If you are just > returning one row of values to use in the form, are you not using drop > lists anywhere in your forms, or has this language you have created for > returning the data to CF handle things like that? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:252113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
