ok....9223372036854775806.5 is what I come up with, and that's fits, but kinda makes our logic a bit kludgy....
what we want to do is from a query, get that number, binary it, use the binary places as on/off switches for feature access, and then bitAnd() the re-done binary string against the full features number, to determine permissions.... so, not having to do that calc would have been cool, but rather than plan for 64 possible features, we might just assume 32 of them, and go from there. since the decimal value of a 32 bit binary string fits fine in the bigint datatype... whatcha think? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -----Original Message----- From: Nelson Winters [mailto:nwinters@;mindspring.com] Sent: Thursday, November 07, 2002 11:53 AM To: CF-Talk Subject: Re: nrotbko: sql server big int I think FF = 1 Byte = 8 Bits AND FFFFFFFFFFFFFFFF = 8 Bytes = 64 Bits 18446744073709551615 = 2^64 However to account for negative numbers, 1 bit is used to determine if the number is positive or negative. So, if I'm correct, the upper limit would be 2^64 or ~ 9.22337 * 10^18 (I can't calculate the number exactly). If you determine the exact value of 2^63, you should be able to store this number, but 2^63 + 1 should not be able to be stored. Nelson ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 11:11 AM 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 Get the mailserver that powers this list at http://www.coolfusion.com
