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 / JavaScript
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
find
myself an example of using a column of datatype Date
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
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 building. I use a dateformatter for the actual
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)
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
,
Muzak
- Original Message -
From: Kevin Aebig [EMAIL PROTECTED]
To: flexcoders@yahoogroups.com
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 SQLite websites but to
no avail
Of Kevin Aebig
Sent: Monday, April 07, 2008 11:43 AM
To: flexcoders@yahoogroups.com
Subject: RE: [flexcoders] AIR SQL - Datatype issues
Hi Fidel,
Actually, the version of SQLite that AIR uses has been customized to
implement dates as julian dates and stores them as REAL. My issue arises
8 matches
Mail list logo