RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case
In addition to this I downloaded a Custom Tag from the tag gallery call CF_Capitalize which does all sorts of nice manipulations. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Steve Oliver [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 23, 2002 11:48 PM > To: CF-Talk > Subject: RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. > sentence case > > > Whoops, looks like I read that wrong. > > http://www.cflib.org/library.cfm?ID=1 > > There's quite a few UDF's for string manipulation there. > > Namely one called CapFirst > > > > __ > steve oliver > cresco technologies, inc. > http://www.crescotech.com > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 23, 2002 11:47 PM > To: CF-Talk > Subject: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence > case > > > Hi, does anyone know how to make FIRSTNAME from a database appear as > Firstname for the purpose of sending emails to customers. > > It would look weird sending emails as: > > Dear FIRST NAME, > > So I'm finding it a challnge to format this properly as: > > Dear Firstname > > Appreciate any help. > > Thanks, > Pardee. > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case
The easiest way would be: #UCase(Left(FIRSTNAME, 1))##LCase(Right(Firstname, Evaluate(Len(Firstname) - 1)))# Or a variance thereof. Hatton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 23, 2002 11:47 PM To: CF-Talk Subject: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case Hi, does anyone know how to make FIRSTNAME from a database appear as Firstname for the purpose of sending emails to customers. It would look weird sending emails as: Dear FIRST NAME, So I'm finding it a challnge to format this properly as: Dear Firstname Appreciate any help. Thanks, Pardee. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case
Whoops, looks like I read that wrong. http://www.cflib.org/library.cfm?ID=1 There's quite a few UDF's for string manipulation there. Namely one called CapFirst __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 23, 2002 11:47 PM To: CF-Talk Subject: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case Hi, does anyone know how to make FIRSTNAME from a database appear as Firstname for the purpose of sending emails to customers. It would look weird sending emails as: Dear FIRST NAME, So I'm finding it a challnge to format this properly as: Dear Firstname Appreciate any help. Thanks, Pardee. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case
You mean getting firstname from a database and sending it in an email? That's pretty simple, something like this: SELECT firstname FROM users Where id = 1 Dear #getUser.firstname#, Blah blah blah __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 23, 2002 11:47 PM To: CF-Talk Subject: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case Hi, does anyone know how to make FIRSTNAME from a database appear as Firstname for the purpose of sending emails to customers. It would look weird sending emails as: Dear FIRST NAME, So I'm finding it a challnge to format this properly as: Dear Firstname Appreciate any help. Thanks, Pardee. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case
Hi, does anyone know how to make FIRSTNAME from a database appear as Firstname for the purpose of sending emails to customers. It would look weird sending emails as: Dear FIRST NAME, So I'm finding it a challnge to format this properly as: Dear Firstname Appreciate any help. Thanks, Pardee. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
