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: 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/4c727b58.7040...@comcast.net