true, but if you do it during the INSERT you only do it once - if you do it
during the SELECT you do it thousands, maybe millions of times.
+-----------------------------------------------+
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: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 12:43 PM
To: CF-Talk
Subject: RE: UCASING in the DB
you could also do the upper function on retrevial of the query.
-----Original Message-----
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 2:56 PM
To: CF-Talk
Subject: RE: UCASING in the DB
in fact, why don't you just put the upper() function in your insert query
like so..
INSERT INTO table
VALUES( upper(#text#), upper(#text#) )
+-----------------------------------------------+
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: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 11:17 AM
To: CF-Talk
Subject: RE: UCASING in the DB
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.
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
