Am 23.08.2010 06:53, schrieb M. Milanuk:
> 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*...
>
Might really be that: try "billed = False" in the second last line.
HTH
Sibylle
_______________________________________________
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]
