I can't, I have to work with the html table because I do this before
creating the SQLTQBLE :
db[request.args(0)].sample_id.represent=\
lambda sample_id, record: A("%(sample)s"
%db.v_sample_num_all[sample_id],\
_href=URL(r=request,f='read',args=request.args(0)+'/'+str(
record.id)))
So, because the ".represent = lambda sample_id, record:" SQLTABLE seems to
need the id column to build the HTML table in the first place... The
sample_id is not the id of the table get by request.args(0)...
That why I wrote the function...
Richard
On Wed, Aug 3, 2011 at 6:50 PM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
> I do not think this qualifies for addition but it is useful.
>
> I would have done:
>
> rows = db().select(db.table.ALL)
> db.table.fieldtodelete.writable=False
> table = SQLTABLE(rows)
>
> or
>
> rows = db().select(*[field for field in db.table if not
> field.name=='fieldtodelete'])
> table = SQLTABLE(rows)
>
>
> On Aug 3, 3:17 pm, Richard Vézina <ml.richard.vez...@gmail.com> wrote:
> > Don't know if my "delete column function" could be part of web2py core
> > functions but here it is :
> >
> > def __del_sqltable_column(sqltable, column_name):
> > """
> > For deleting a given column in an instance of web2py SQLTABLE class.
> > Pass the SQLTABLE object and the column name to delete.
> > Ex.: table1 = SQLTABLE(rows) contains id column and we want to delete
> > it.
> > So we call __del_sqltable_column(tabel1, 'table.id') or
> > __del_sqltable_column(request.args(0), db[request.args(0)].id)
> > When the column name is changed with represent the representation
> should
> > be
> > passed as column name.
> > """
> > import re
> > regex_colum_name = re.compile(str(TH(column_name)))
> > for i in range(0, len(sqltable[0][0])):
> > if regex_colum_name.match(str(sqltable[0][0][i])):
> > for r in range(0, len(sqltable[1])):
> > del(sqltable[1][r][i])
> > del(sqltable[0][0][i])
> > return sqltable
> > return sqltable
> >
> > It could be my first contribution to web2py ;-)
> >
> > Richard
> >
> > On Wed, Aug 3, 2011 at 4:08 PM, Richard Vézina
> > <ml.richard.vez...@gmail.com>wrote:
> >
> >
> >
> >
> >
> >
> >
> > > Yes... I use pgAdmin for the other things, I didn't fix my choice on a
> > > commercial database manager...
> >
> > > ;-)
> >
> > > Richard
> >
> > > On Wed, Aug 3, 2011 at 4:04 PM, Anthony <abasta...@gmail.com> wrote:
> >
> > >> I think he wants to delete columns from a SQLTABLE, not a db table.
> >
> > >> On Wednesday, August 3, 2011 4:01:09 PM UTC-4, pbreit wrote:
> >
> > >>> That's how I delete columns.
>
