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

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

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_id ==

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
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 but

[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,