Well, the trigger or stored procedure would keep the formatting with the data and theoretically makes it easier to handle a situation where other external applications ( ASP, client-server, etc. ) which you might not have any control over would be accessing the same DB. Admittedly, this is a fairly uncommon situation.
S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > Sure it is. You have two choices - a trigger or a stored procedure. I > think you are way better off leaving it the CF server though (unless > you're talking about thousands of characters per second...). > +-----------------------------------------------+ > Bryan Love > Macromedia Certified Professional > Internet Application Developer > Database Analyst > TeleCommunication Systems > [EMAIL PROTECTED] > +-----------------------------------------------+ > "...'If there must be trouble, let it be in my day, that my child may have > peace'..." > - Thomas Paine, The American Crisis > "Let's Roll" > - Todd Beamer, Flight 93 > -----Original Message----- > From: Brian Thornton [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 20, 2002 11:01 AM > To: CF-Talk > Subject: UCASING in the DB > Is it possible to insert lcase values in a SQL2K db and have it > automatically ucase them in the database? > Purpose: To take ucasing processing off the CFserver and onto the SQL > server. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
