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
You can with a trigger...
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101
*** Please vote for iMS here:
http://www.sys-con.com/coldfusion/readerschoice2002/nominationform.cfm ***
inFusion Mail Server (iMS) - The Award-winning,
: 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
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
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
: 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
6 matches
Mail list logo