[flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-27 Thread Amy
--- In flexcoders@yahoogroups.com, "Charlie Hubbard" <[EMAIL PROTECTED]> wrote: > > Ok thanks Johannes. Very good point. Number's can't really be NULL either. > However, it just so happens that NaN is interpreted as NULL to the datatype > conversion layer in AIR and it just happens to work ou

Re: [flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-26 Thread Charlie Hubbard
Ok thanks Johannes. Very good point. Number's can't really be NULL either. However, it just so happens that NaN is interpreted as NULL to the datatype conversion layer in AIR and it just happens to work out. Maybe this slight difference between NaN and NULL doesn't really matter, but it's good

Re: [flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-24 Thread Johannes Nel
on debug level it evaluates to NaN, which should insert as NULL.but then remember var n:Number; // == NaN var p:Number = n + 1;//==NaN var q:int = n+1;//==0 On Mon, Nov 24, 2008 at 9:01 PM, Charlie Hubbard <[EMAIL PROTECTED]>wrote: > So if I can sum up your email very clearly. I'd say: > > DO

Re: [flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-24 Thread Charlie Hubbard
So if I can sum up your email very clearly. I'd say: DO NOT use int, use Number, because that's what Air's database connection layer is going to return you. If you use int data type for fields you'll get zeros. With Number it's will propagate NULLs correctly. Thanks, Charlie On Mon, Nov 24, 2

[flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-23 Thread jason_williams_mm
--- In flexcoders@yahoogroups.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 g

[flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-23 Thread Amy
--- In flexcoders@yahoogroups.com, "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 ge

RE: [flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-23 Thread Mark Easton
Charlie Hubbard Sent: Monday, November 24, 2008 9:02 AM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Re: AIR SQLLite, ints, and NULLs 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 wha

Re: [flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-23 Thread Charlie Hubbard
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 a

[flexcoders] Re: AIR SQLLite, ints, and NULLs

2008-11-23 Thread Amy
--- In flexcoders@yahoogroups.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