How is it done in the sql statement. I'm thinking that would be the best
way to go since the data needs to be kicked out to a pdf.
Thanks,
j
-----Original Message-----
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 6:08 PM
To: CF-Talk
Subject: RE: Quick format question
a number of ways:
it is probably best to do it in the SQL statement if you have a lot of
records,
If you can't do it that way and you still have a lot of records then try
this:
<cfoutput><cfset foo = insert(") ","1234567890",3)>
(#insert("-",foo,8)#</cfoutput>
The above method is fast, but this one is easier to understand:
(#left(phone,3)#) #mid(phone,4,3)#-#right(phone,4)#
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 1:04 PM
To: CF-Talk
Subject: Quick format question
How do format for phone numbers I want it to print out like:
(===) ===-====
I didn't see it in the CF books.
thanks,
j
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists