Nick,
Thanx for your help -- float worked fine --
Cori
At 03:27 PM 5/15/2001 +0100, you wrote:
>Column IxxEPV in table Mech now has the datatype float?
>
>Nick
>
>-----Original Message-----
>From: Corina Moore [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, May 15, 2001 2:44 PM
>To: SQL
>Subject: RE: Exponentials & Data Types
>
>
>I turned the field into a float and then tried to enter the number
>2.63e11
>This is the error that I got back.... Not sure what I am doing wrong...
>Thanx in advance....
>
>ODBC Error Code = 22003 (Numeric value out of range)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error
>converting float to data type numeric.
>SQL = "UPDATE dbo.Mech SET IxxEPV = 2.63e11 Where MechID = 12
>
>Cori
>
>At 09:43 AM 5/15/2001 +0100, DeVoil, Nick wrote:
> >Corina
> >
> >You want float.
> >
> > From the docs:
> >
> >float [ ( n ) ]
> >
> >Is a floating point number data from - 1.79E + 308 through 1.79E + 308. n
>is
> >the number of bits used to store the mantissa of the float number in
> >scientific notation and thus dictates the precision and storage size. n
>must
> >be a value from 1 through 53.
> >
> >Nick
> >
> >-----Original Message-----
> >From: Corina Moore [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, May 14, 2001 9:18 PM
> >To: SQL
> >Subject: Exponentials & Data Types
> >
> >
> >Our users need to be able to enter exponential information.
> >(ex: 2.63e11)
> >After they enter the information we need to be able to do calculations on
> >it (mostly subtracting one exponential from another exponential)
> >Any have any thoughts on the best data type to handle this.
> >Thanx...
> >*********************************
> >Corina S. Moore
> >IMDC Software Developer
> >301-286-6124
> >http://imdc.nasa.gov
> >**********************************
> >
> >
> >**********************************************************************
> >Information in this email is confidential and may be privileged.
> >It is intended for the addressee only. If you have received it in error,
> >please notify the sender immediately and delete it from your system.
> >You should not otherwise copy it, retransmit it or use or disclose its
> >contents to anyone.
> >Thank you for your co-operation.
> >**********************************************************************
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
