[web2py] Re: smartgrid query on 2 or more tables

2012-03-05 Thread Roderick
to do this from appadmin but that doesn't use grids :( and I'd prefer to give my users a cleaner interface... ) Thanks! Roderick On Mar 1, 8:51 am, Johann Spies johann.sp...@gmail.com wrote: On 29 February 2012 16:44, Roderick roderick.m...@gmail.com wrote: Thanks Johann! 1. Can this be done

[web2py] smartgrid query on 2 or more tables

2012-02-29 Thread Roderick
Hi web2py users! 1. Can anyone tell me if the query input field on SQLform smartgrid forms can do a join on 2 or more tables? 2. If so, how do I construct such a query? My attempts my failed and can't find docs on this either... Note - I would like users to be able to construct and type in their

[web2py] Re: smartgrid query on 2 or more tables

2012-02-29 Thread Roderick
Thanks Johann! 1. Can this be done with smartgrid? 2. Can you give me an example of a dynamic query (e.g. what users would type into the search field)? (for grid or smartgrid). Thanks! On Feb 29, 2:44 pm, Johann Spies johann.sp...@gmail.com wrote: Apololgies, Gmail's web interface and I am not

[web2py] Re: sqlhtml.py - breadcrumbs exception when using smartgrid format + lambda

2012-02-16 Thread Roderick
Hi Massimo and Anthony Created the following issue: http://code.google.com/p/web2py/issues/detail?id=663 Unfortunately the fix doesn't work on the breadcrumbs - still getting the index - although it does work on row data... Thanks regards, Roderick On Feb 14, 4:44 pm, Massimo Di Pierro

[web2py] Re: SQLFORM.smartgrid links to reference field

2012-02-15 Thread Roderick
For now I've hacked sqlhtml.py with the following to achieve this: in smartgrid def after the first try block (i.e. following line 1938 (v1.99.4): redirect(URL(args=table._tablename))) # RM: mod to create links in reference fields if linked_tables: for field

[web2py] sqlhtml.py - breadcrumbs exception when using smartgrid format + lambda

2012-02-14 Thread Roderick
Hi! When I use a lambda function for the format attribute of a table, display the table in a smartgrid and click a linked table, the referring table is shown by id instead of by the lambda representation. The format works fine elsewhere (e.g. in smartgrid rows). I think this part of sqlhtml.py is

[web2py] Re: sqlhtml.py - breadcrumbs exception when using smartgrid format + lambda

2012-02-14 Thread Roderick
Being a noob at Python and Web2py, this is the best I could come up with: In sqlhtml.py, insert the 2nd try block (below name = db[referee]._format % record) as follows: try: name = db[referee]._format % record except TypeError:

[web2py] Re: SQLFORM.smartgrid links to reference field

2012-02-13 Thread Roderick
bump... anybody?

[web2py] Re: Too many redirects when trying to use interactive demo

2012-02-07 Thread Roderick
/site; doesn't help. My own web2py site on a separate server works fine (if that means anything). Regards, Roderick On Feb 3, 3:52 pm, Wikus van de Merwe dupakrop...@googlemail.com wrote: The problem seems to be a redirection loop between this two addresses: 1)http://web2py.com/demo_admin

[web2py] SQLFORM.smartgrid links to reference field

2012-02-07 Thread Roderick
- dog: coco, owner: roderick. I'd like to click on coco (roderick) and get his entry from the dogs(owners) table. (Similar to what happens if I first go to the dogs table, and in coco's row I click the dog_owners button which shows me all owners of coco and gives a link back to coco if you know what I