--- In [email protected], "Charlie Hubbard" <[EMAIL PROTECTED]> wrote: > > Thanks Amy, but I was really asking for what I can use as a substitute data > type for an int since you can't have NULLs for an int. So far from what I'm > finding is I can use Number in place of int and also get a null value for a > Number into the DB. At least it seems that way so far. If I change all of > my int's to Number's then I start getting NULLs as expected for values that > are unset. So I guess I really trying to validate that fact with other > Actionscripters out there to see if this is acceptable or if not is there a > better option. Can I use Number place of int and not run into any problems > down the road?
I think the main issues you could face are that Numbers use sllightly more memory than ints and that there's some possibility that you could wind up with a decimal value in there accidentally. Sometimes you get strange rounding errors with numbers due to precision problems with how computers store numbers. Try something like: yourNum==undefined?null:yourNum in whatever statement you're using to populate the database. HTH; Amy
