Denny,
try changing the datatype to Varchar and make sure you set the size to
atleast 15 or what you want!
make sure you have the brackets correct and quotes in place
<cfquery Name="" Datasource="Phone_Numbers">
insert into Table_name values('#Phone_number#')
</Cfquery>
----- Original Message -----
From: "Denny dd" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 23, 2000 2:21 PM
Subject: Problem in insertinf Phone number
> Hi!
> I am facing a wierd problem .
> When ever I am trying to Insert field Phone# through the Insert form in
the
> format (XXX-XXX-XXXX),the value inseted in the database is only the last 4
> digits .Suppose the phone number I have inserted is 718-567-6789 ,only
6789 is
> taken by the database and not 718-567-6789.
> First I specified Phone number as "number" datatype ,it was not working
then I
> tried by specifying datatype as "Text" still its not working
> Please help.
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
