> Hi All- making some progress here in week 1 with web2py... > I wrote my postgres database first, and generated the model from it.. > and that is working well ..
1) build your models in Web2py and let it create your DB schema > But I have one *postgres* view, which is about 5 joins.. I dont yet > understand.. > Do i have to write this out in the web2py *QL, or can I execute sql > and return it somehow .. 2) try to first use Web2py DAL. Maybe his answer was not what you expected but it is surely related and correct. > (I do not yet understand how I specify response._vars and such for > web2py views... > - will re-read while researcing ) > the ideal interface would be something like : > choose a concat of date + company from a popup at the top.. > or, heck, just the pkey for now > get a collection of 250 formatted rows in a scrolling window below, > per popup choice > The rows are filled in by 3 joins from a central table to 3 fk_tables > The popup choice fills in company info in the header.. I suggest posting the table details so that anyone willing to help can reply with web2py specific code samples. > thanks in advance for leads on this.. > -Brian
