I think instead of patching there should a repository of SQLFORMxxx.py and SQLTABLExxx.py that you put in your models and do different things when you need.
Massimo On 27 Apr, 08:50, DenesL <denes1...@yahoo.ca> wrote: > On Apr 27, 5:59 am, Timmie <timmichel...@gmx-topmail.de> wrote: > > > I liked this option most. > :) > > > Here is the function I derived from this: > > > def rows_transpose(rows_obj): > > """transposes a rows object > > > input: a rows object selected from the data base > > output: a html table of the transposed table > > > This can still be improved by using the headers attribute of the > > SQLTABLE and a CSS alogn attribute > > """ > > > tbody=[] > > for col in rows_obj.colnames: > > fld=col.split('.')[1] > > r=[TH(col,_scope='row', _style="text-align : left")] > > for row in rows_obj: > > r.append(TD(row[fld])) > > tbody.append(TR(r)) > > res_table=TABLE(tbody) > > > return res_table > > > Although the numpy version was faster, this function gives more > > control over the html output. > > > I would be great if such a functionality could be included in web2py! > > This could be in patched into SQLTABLE but I don't have the time right > now. > > > I still have the following questions: > > > * How can I retrieve and use the default field lables set in the model > > as colnames? > > h={} > for c in rows.colnames: > tbl,fld=c.split('.') > h[c]=rows._db[tbl][fld].label > tt=SQLTABLE(rows,headers=h) > > > * When I put this function in an extra module file and save this in > > applications.myapp.helper.py > > I get the following error: > > > File "applications\myapp\modules\helper.py", line 27, in > > rows_transpose > > r=[TH(col,_scope='row', _style="text-align : left")] > > NameError: global name 'TH' is not defined > > > Why this? How can I have modules which are awar of the web2py > > namespace in the modules folder? > > Or shall I leave such helper functions in the default.py? > > In your module you have to import the helpers: > from gluon.html import * > > > > > Regards, > > Timmie > > Denes --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---