I have received your e-mail but will be out of the office 9/9/01. I will be checking
messages while away and will get back to you as soon as possible. If this is an
urgent request please contact Dan Tesenair.
Thank you,
Darren Houle
Sr. Web Developer
>>> cf-talk 08/31/01 18:07 >>>
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
