On 5/12/11 12:00 PM, John Fabiani wrote:
> 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???
Set DataStructure explicitly.
Paul
_______________________________________________
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]
