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?
Charlie On Sun, Nov 23, 2008 at 1:37 PM, Amy <[EMAIL PROTECTED]> wrote: > --- In [email protected] <flexcoders%40yahoogroups.com>, > "Charlie Hubbard" > <[EMAIL PROTECTED]> wrote: > > > > I've read over all of the docs on Air, but there seems to be a missing > > discussion around NULL values in SQLLite and how those map back to > > datatypes. What I've found is that if I have an int field type I > can't get > > a NULL value to ever get inserted into the SQLLite. It just ends up > > inserting 0 (zero). In Java we'd just convert to using a true Object > like > > Integer class, and that would handle this problem for us. What is the > > equivalent with Actionscript? If you want NULLs and numbers what is > an > > object and a number, and will Air convert between the two correctly? > > I don't believe null is an acceptable value for an int in Actionscript > 3, so as long as you're using an int datatype, you'll have to check for > maybe undefined or something and insert null vs. the actual variable > value. Check the docs for the specifics of what the "empty" value is > for int. > > HTH; > > Amy > > >
