The all-F's number in calculator is unsigned, and I bet BigInt is signed, so
you loose one bit. That generally means you have to divide by two and
subtract one to get the largest positive integer that fits.
Mark
-----Original Message-----
From: Tony Weeg [mailto:tony@;navtrak.net]
Sent: Thursday, November 07, 2002 11:12 AM
To: CF-Talk
Subject: nrotbko: sql server big int
18446744073709551615
is what I come up with when I type FFFFFFFFFFFFFFFF
into my calculator, and transform hex to decimal.
FF = 1 Bit
FFFFFFFFFFFFFFFF = 8 Bits
BigInt as a datatype is an 8 Bit datatype right?
but I cant put this value....
18446744073709551615
into a big int field?
any ideas on that ceiliing anyone?
thanks.
.tony
Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
