RE: Quick format question

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

RE: Quick format question

How is it done in the sql statement. As always with anything to do with string functions or date functions, the answer is, it depends what DBMS you're using. Nick ** Information in this email is confidential and may be

RE: Quick format question

CFSET formatPhoneNumber='#Mid(PhoneNumber,1,3)#-#Mid(PhoneNumber,4,3)#-#Mid(PhoneN umber,7,4)#' -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

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: cfoutputcfset foo = insert() ,1234567890,3) (#insert(-,foo,8)#/cfoutput The above method is fast, but this one is

RE: Quick format question (I have received your e-mail but will be out of the office)

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

RE: Quick format question (I have received your e-mail but willbe out of the office) (I have received your e-mail but will be out of the office)

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:25 I have

RE: Quick format question

Janine, Try using the CFINPUT tag. You will need to use CFFORM as opposed to FORM/FORM. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

RE: Quick format question (I have received your e-mail butwillbe out of the office) (I have received your e-mail but will be outof the office) (I have received your e-mail but will be out of the office)

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:57 I have