Hey Muzak, I've actually tried a few of those from references at SQLite websites but to no avail. I think it has something to do with the way the DB is handling data typing as I've heard that SQLite will actually allow unique datatypes to each cell instead of column.
Thanks a lot 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 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) VALUES (CURRENT_TIMESTAMP) More info on this page: http://livedocs.adobe.com/flex/3/langref/localDatabaseSQLSupport.html Look for: "Date and time formatting functions" and "Time formats" (about 3/4 down the page). regards, Muzak ----- Original Message ----- From: "Kevin Aebig" <[EMAIL PROTECTED]> To: <flexcoders@yahoogroups.com> Sent: Monday, April 07, 2008 5:22 PM Subject: [flexcoders] AIR SQL - Datatype issues > 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 / JavaScript Date objects, but > I can't get it to work properly for the life of me. Any examples or > pointers? > > > > Cheers, > > > > !k > > ------------------------------------ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.comYahoo! Groups Links