On Feb 28, 2009, at 4:08 PM, Roger Lovelock wrote:
> I think I have answered my own question (at leat partially) -
> internally in
> SQLite I think that the dates are stored in YYYY-MM-DD format - so I
> could
> just concatenate the fields. Problem is, I suspect, that that
> wouldn't be a
> portable solution to other databases - so ... any suggestions?
The answer depends on where you're doing the sorting. If you're
sorting the data in your query, just add 'order by' values to the SQL.
If you already have a dataset and want to order it, remember that
datasets understand SQL themselves. So if you have a dataset named
'ds', just do:
orderedDS = ds.execute("select * from dataset order by account_type,
datefield")
This will return a new dataset ordered as you requested. See
http://dabodev.com/wiki/DataSet
for more about this.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
