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: Dabo-users@leafe.com 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/4c72401a.3080...@t-online.de