INSERT INTO table
(SSN)
VALUE (#Replace("#FORM.SSN#", "-", "", "ALL")#)
<CFOUTPUT>
<CFSET ssn1 = #Insert("-", "#QUERYNAME.SSN#", "4")#
<CFSET ssn2 = #Insert("-", "#ssn1#", "7")#
#ssn2#
</CFOUTPUT>
Just real quickly - you may need to tweak . .
Dave
=================================
"What we need is a list of specific unknown problems we will encounter"
David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
----- Original Message -----
From: "Kim Ahlbrandt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 30, 2000 2:18 PM
Subject: formatting social security number
I need to take the dashes out of a social security number before storing to
the database, and then put them back in when the page is brought up again
later. Is there a way to do this in coldfusion??
Thanks,
Kim
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
