Hi,
If I do something like the following a datatype is changed from date to string
depending on the first record of the dataset.
fields:
mustenrollby = date
referral = date
first record
mustenrollby = Null
referral = '2011-04-10'::date
second record
mustenrollby = '2011-04-24'::date
referral = '2011-04-10'::date
aliasDict = {"bd":dsBalanceDue} # contains only 3 fields not mustenrollby
dsNew = ds.execute("""select dataset.*, bd.course_cost as bd_course_cost,
bd.paid_amt as bd_paid_amt
from dataset join bd on dataset.enrollid = bd.enrolleeid order by
dataset.lname""", cursorDict=aliasDict)
after executing the above the data type for the second record - mustenrollby
is now a string.
or u'2011-04-24'
If the first record contains a real date the change does not happen???
Johnf
_______________________________________________
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]
