Revision 5180:
------------------------------------------------------------------------
r5180 | ed | 2009-04-18 06:55:13 -0700 (Sat, 18 Apr 2009) | 2 lines
Changed paths:
M /trunk/dabo/biz/dBizobj.py
M /trunk/dabo/db/dCursorMixin.py
Revamped the code for determining the alias used in a child filter.
Previously the bizobj's DataSource was used, which incorrectly assumed
that that would be the correct alias. This addresses the issue (Trac
#1228) raised by Sibylle Koczian.
------------------------------------------------------------------------
Causes the following traceback in my app:
Traceback (most recent call last):
File "sbs_studio.py", line 162, in <module>
main()
File "sbs_studio.py", line 137, in main
hasValidCustomers = app.hasValidCustomers()
File
"/home/pmcnett/py/sbs/shutter_studio/trunk/clients/shutter_studio/App.py",
line 808, in hasValidCustomers
biz.requery()
File "/home/pmcnett/dabo-full/trunk/dabo/biz/dBizobj.py", line 905,
in requery
self.requeryAllChildren()
File "/home/pmcnett/dabo-full/trunk/dabo/biz/dBizobj.py", line 1433,
in requeryAllChildren
child.requery()
File "/home/pmcnett/dabo-full/trunk/dabo/biz/dBizobj.py", line 886,
in requery
cursor.requery(params)
File "/home/pmcnett/dabo-full/trunk/dabo/db/dCursorMixin.py", line
434, in requery
self.execute(currSQL, params, _newQuery=newQuery)
File "/home/pmcnett/dabo-full/trunk/dabo/db/dCursorMixin.py", line
329, in execute
raise dException.DBQueryException(errMsg, sql)
dabo.dException.DBQueryException: no such column: prod_cust.cust_id.cust_id
SQL: select prod_cust.id as id,
prod_cust.prod_id as prod_id,
prod_cust.cust_id as cust_id,
prod_cust.sf_price as sf_price,
prod_cust.is_default as is_default,
prod_cust.notes as notes,
product_lines.name as product_line_name,
product_lines.sf_price as default_sf_price,
customers.account as customer_account,
customers.name as customer_name
from prod_cust
left join product_lines
on product_lines.id = prod_cust.prod_id
left join customers
on customers.id = prod_cust.cust_id
where prod_cust.cust_id.cust_id =
'b71c418a-a04e-40fa-a534-5283e0998ca3'
group by prod_cust.id
limit 2000
It should be 'prod_cust.cust_id' and not 'prod_cust.cust_id.cust_id'.
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[email protected]
