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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
