That was what I meant... if YOU controlled it from its early days as a wee little datasource to its current teenage years and taught it about the birds and the bees and how to drive... then you should handle those things before it gets entered. Most of us have been through the nightmares that poor data validation can and will cause with a 'hand me down' database.
....but... I'm not bloating my application with checks for any FUTURE developers mistakes ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 5:01 PM To: CF-Talk Subject: RE: Employee name If you created the datasource and you wrote the code that puts the data into it, you shouldn't have to check for any of these things when pulling the data back. True for as far as it goes, but I do a lot of work where I did not create the database schema (but I did create a datasource that points to it) and I did not create the code that puts the data into it. But I have to create the web output from this. So I would advice, based on my experience, don't count on the format of the data going in unless you HAVE created the database, and one and only data manipulation program and will ever be the only one to do so FOR ALL TIME. Otherwise, those of us who are not one-man shows write our output to gracefully handle, as best as we can, the unexpected because there is almost always something unexpected! -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
