Re: [web2py] SQLFORM.grid not doing what I want :)

2012-03-30 Thread Mike Veltman
After testing form = SQLFORM.grid(query, fields=fields, field_id=db.lvdisksetup.id, <--- orderby=['lvdisksetup.lunid'], csv=False, create = True, maxtextlength=45 ) It worked like a ch

Re: [web2py] SQLFORM.grid not doing what I want :)

2012-03-30 Thread Mike Veltman
I guessed it was something like that :-) Thanks Massimo I am going to test it. On 03/30/2012 10:51 AM, Massimo Di Pierro wrote: You have to pass it SQLFORM.grid(...,field_id=db.lvdisksetup.id,) else it does not know what table to use. On Thursday, 29 March 2012 19:58:52 UTC-5, Gwayne ak

Re: [web2py] SQLFORM.grid not doing what I want :)

2012-03-29 Thread Massimo Di Pierro
You have to pass it SQLFORM.grid(...,field_id=db.lvdisksetup.id,) else it does not know what table to use. On Thursday, 29 March 2012 19:58:52 UTC-5, Gwayne aka Mike Veltman wrote: > > On 03/30/2012 12:01 AM, Massimo Di Pierro wrote: > > When you say "I want to manipulate db.lvdisksetup b

Re: [web2py] SQLFORM.grid not doing what I want :)

2012-03-29 Thread Mike Veltman
On 03/30/2012 12:01 AM, Massimo Di Pierro wrote: When you say "I want to manipulate db.lvdisksetup but in stead it manipulates db.lvdisk" what do you mean by "manipulates"? That when I delete a record or do add a record it gives me the db.lvdisk table and not the db.lvdisksetup table. So I

Re: [web2py] SQLFORM.grid not doing what I want :)

2012-03-29 Thread Massimo Di Pierro
When you say "I want to manipulate db.lvdisksetup but in stead it manipulates db.lvdisk" what do you mean by "manipulates"? On Wednesday, 28 March 2012 22:58:31 UTC-5, Gwayne aka Mike Veltman wrote: > > Gentle people, > > I have the following grid: > > query = ( (db.lvdisksetup.lvgroupname_

[web2py] SQLFORM.grid not doing what I want :)

2012-03-28 Thread Mike Veltman
Gentle people, I have the following grid: query = ( (db.lvdisksetup.lvgroupname_id == usedlvdisksetup) & (db.lvgroupname.id == usedlvdisksetup) & (db.lvdisksetup.lvdisk_id == db.lvdisk.id) ) fields = [db.lvdisksetup.id, db.lvgroupname.lvgroupnamedesc , db.lvdisk.lvdiskdesc, db.lvdisksetup