using date field in air, sqlite

15 views
Skip to first unread message

whitekross

unread,
Nov 2, 2009, 6:02:52 PM11/2/09
to JazzRecord
hi,

i'm currently using JazzRecord for an air desktop app, and it's great.
i just had some problems working with date field in sqlite, and i
didnt find nothing about that on the online documentation.

maybe it's a simple question, because i'm a newbie on this kind of
project...but, there is a simple way to handle a date field in
JazzRecord? a data type, or something that i can set when define a new
model?

Nick Carter

unread,
Nov 2, 2009, 6:17:10 PM11/2/09
to JazzRecord
Hi, and thanks for using JazzRecord!

As sqlite doesn't internally give a crap about the contents of its
columns, I've mostly just been using strings for storing dates, in
conjunction with getTime() calls on any Date objects.

Would you like to see actual JS Date objects converted/retrieved by
JazzRecord? This may be doable, but will cost some overhead when
loading a large number of records, each with a date field.

If we add it we'd need to add lots of "BE CAREFUL" verbiage in the
documentation regarding this, but for solo record loading it might be
cool.

whitekross

unread,
Nov 3, 2009, 4:43:43 AM11/3/09
to JazzRecord
ah, cool, works great!
thanks a lot for your help ;)
Reply all
Reply to author
Forward
0 new messages