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:252106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
