Another option might be to explicitly create a SQLTABLE object ( http://web2py.com/book/default/chapter/06#Serializing-Rows-in-Views), and then either in the controller or view, alter the SQLTABLE via the server-side DOM (see http://web2py.com/book/default/chapter/05#Server-side-DOM-and-Parsing). On Wednesday, April 20, 2011 9:39:49 AM UTC-4, Mike wrote:
> *****DISCLAIMER: NEWBIE ABOARD!******* > I'm trying to display a table of the database with 'edit' URL links > (that point to another function) tacked on at the last column. I saw > that the SQLTABLE has a linkto= option but I don't want to change the > look of the link and don't want it to display as the id. I've seen > this topic covered to death in this list: > > > http://groups.google.com/group/web2py/browse_thread/thread/d03a872237c39992/824afafa014c1cb2?lnk=gst&q=sqltable+url+links+colum#824afafa014c1cb2 > > > > http://groups.google.com/group/web2py/browse_thread/thread/a0c789cccafe8014/f1f96197a13cfeb7?show_docid=f1f96197a13cfeb7 > > > but am still hitting some walls in my own implementation. > > I would really prefer not to start doing stuff inside the model/ > database since this is merely a display issue and I don't want to > clutter up my database with a new column. I also don't want to add a > 'patch' as I'm worried about breaking something during upgrading down > the road. > > Is the easiest way forward to build the table by hand doing something > like this? > > controller: > selection = db(db.table).select() > > view: > {{for rows in selection:}} {{=rows}} {{insert custom column logic}} > {{pass}} > > Thanks in advance for any advice.
