RE: UCASING in the DB

2002-09-20 Thread Bryan Love
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

Re: UCASING in the DB

2002-09-20 Thread Howie Hamlin
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,

RE: UCASING in the DB

2002-09-20 Thread Bryan Love
: 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

RE: UCASING in the DB

2002-09-20 Thread S . Isaac Dealey
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

RE: UCASING in the DB

2002-09-20 Thread Matthew Friedman
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

RE: UCASING in the DB

2002-09-20 Thread Bryan Love
: 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