M. Milanuk wrote:
> 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*...
Are you by chance using sqlite as a db? I am and I had to change
billed=false to billed = 0 to get past that error message.
> 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...?
I noticed it also.
> TIA,
>
> Monte
Regards, Jim
_______________________________________________
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]
