Been banging my head on the wall on this one for a while... started over
from scratch once just to be sure.
At the tail end of the 'Adding the Billing Grid' section of the PyCon
Tutorial, where we go in and edit the HoursBizobj.py file to add the
join between the hours and clients table... things stop working and I
get the following error message (twice, each time, every time):
Dabo Error Log: Sun Aug 22 21:36:44 2010: Database Execution failed with
response: no such column: false
Dabo Error Log: Sun Aug 22 21:36:46 2010: Database Execution failed with
response: no such column: false
I've checked and double-checked my code in HoursBizobj.py; I also went
in and commented out the new lines and re-ran the program with no
problem. Uncomment the lines and it coughs up the errors as shown, and
all the fields of the form are blank.
Here is the modified section of HoursBizobj.py:
class HoursBizobj(dabo.biz.dBizobj):
def afterInit(self):
self.DataSource = "hours"
self.KeyField = "pkid"
self.addFrom("hours")
# self.addJoin("clients",
# "hours.clientfk = clients.pkid")
self.addField("hours.clientfk")
self.addField("hours.hours")
self.addField("hours.notes")
self.addField("hours.billed")
self.addField("hours.servicedate")
self.addField("hours.pkid")
# self.addField("clients.clientname")
# self.addWhere("billed = false")
# self.addOrderBy("servicedate asc")
As far as I can tell it matches (except the comment marks of course)
what is shown in the tutorial.
I'm hoping this is a simple typo somewhere on my part, but I'll be
dipped if I can figure *where*...
Also in the same section: 'Adding the Billing Grid', the document
appears to have us adding the code for the getNamesAndKeys() method
twice... both times it says to add the new method to
biz/ClientBizobj.py... about a page apart. The code blocks look
identical, as near as I can tell. The second time is after setting the
RegID for the Client Dropdown List to 'ClientList' and then adding the
code to afterInitAll(self) for same. Maybe I read that wrong and thats
where I'm screwing myself up later...?
TIA,
Monte
_______________________________________________
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]
