On Jul 13, 2009, at 8:07 PM, tim awa wrote:
> Ops! Some typos in original post.
>
> The ff JOIN does not work:
>
> aliasDict = { "curPhone" : phoneDS }
> ds = nameDS.execute("select dataset.fullname, curPhone.phone from
> dataset join curPhone on dataset.pk=curPhone.fkName", aliasDict)
>
> The error returned is:
>
> "OperationalError: no such table: curPhone"
That's odd - I just tried something like this, and it worked fine.
Do the results change if you use all lower-case names for the
aliases? E.g.,
aliasDict = { "phn" : phoneDS }
-- 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]
