RE: [flexcoders] AIR SQL - Datatype issues

2008-04-07 Thread Randy Martin
omplete -- is doesn't have the error handler or the insertComplete handler. HTH, ~randy _ From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Aebig Sent: Monday, April 07, 2008 11:43 AM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] AIR SQL - Data

Re: [flexcoders] AIR SQL - Datatype issues

2008-04-07 Thread Muzak
mail: regards, Muzak - Original Message - From: "Kevin Aebig" <[EMAIL PROTECTED]> To: Sent: Monday, April 07, 2008 9:02 PM Subject: RE: [flexcoders] AIR SQL - Datatype issues > Hey Muzak, > > I've actually tried a few of those from references at SQLi

RE: [flexcoders] AIR SQL - Datatype issues

2008-04-07 Thread Kevin Aebig
ot for the examples... hopefully something clicks. Cheers, !k -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Muzak Sent: Monday, April 07, 2008 1:12 PM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] AIR SQL - Datatype issues CREATE TABL

Re: [flexcoders] AIR SQL - Datatype issues

2008-04-07 Thread Muzak
CREATE TABLE tbl_test ( testID INTEGER PRIMARY KEY AUTOINCREMENT , field1 DATE ) All of the following work: INSERT INTO tbl_test (field1) VALUES ('now') INSERT INTO tbl_test (field1) VALUES ('2008-04-07 20:57:44') INSERT INTO tbl_test (field1) VALUES ('2008-04-07') INSERT INTO tbl_test (field1) V

RE: [flexcoders] AIR SQL - Datatype issues

2008-04-07 Thread Kevin Aebig
ders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Vaan S Lanko Sent: Monday, April 07, 2008 10:39 AM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] AIR SQL - Datatype issues Hey Kevin, Heres an example of some sql text on a SQLStatement that I use in an AIR app I'm buildi

Re: [flexcoders] AIR SQL - Datatype issues

2008-04-07 Thread Vaan S Lanko
Hey Kevin, Heres an example of some sql text on a SQLStatement that I use in an AIR app I'm building. I use a dateformatter for the actual date output i.e '2008-04-06' and if I need the time component, I just build up and replace the end of the text with my vars, its not pretty but it works fi

RE: [flexcoders] AIR SQL - Datatype issues

2008-04-07 Thread Kevin Aebig
s.com Subject: Re: [flexcoders] AIR SQL - Datatype issues On Mon, Apr 7, 2008 at 4:22 PM, Kevin Aebig <[EMAIL PROTECTED] <mailto:kevin%40keslabs.com> com> wrote: > Hey all, > > > > I've looked at the documentation about 400 times now and can't seem to fin

Re: [flexcoders] AIR SQL - Datatype issues

2008-04-07 Thread Fidel Viegas
On Mon, Apr 7, 2008 at 4:22 PM, Kevin Aebig <[EMAIL PROTECTED]> wrote: > Hey all, > > > > I've looked at the documentation about 400 times now and can't seem to find > myself an example of using a column of datatype Date within AIR SQL. I know > that it's been customized to use Actionscript / Java