#Created a new application 'charges' which utilizes MySQL Server with the 
following:
#At the model file (produce_files.py):
db.define_table('owner',
                Field('name','string'),
                Field('address','string'),
                format='%(name)s'
                )

db.define_table('dog',
                Field('dogname','string',length=15,label='Onoma Skylou'),
                Field('owner',db.owner, label='Idioktitis',readable=False),
                format='%(dogname)s'
                )
db.dog.id.readable = False

#At the controller file (test.py):

from gluon import *

@auth.requires_login()
def testStarter():
    """This is to explore SQLFORM.smartgrid capabilities"""
    grid = 
SQLFORM.smartgrid(db.owner,fields=[db.owner.name],linked_tables=['dog'])
    return locals()
#At the view file (test/appStarter.py):

{{extend 'layout.html'}}

{{=grid}}

I use the appadmin of the application to populate the 'owner' table with an 
owner, as well as the 'dog' table with a dog for that owner.

Now, when I visit http://127.0.0.1/charges/test/testStarter.html I get to 
see the 'owner' table in the grid, as well as the 'dogs' link. Everything 
seems ok, BUT: when I click on the 'dogs' link for the sole owner I have 
already inserted, there is no dog there. The header of the fields for the 
dog grid is not shown, and the header for the 'owner' table is shown 
instead. Nevertheless, the application reports correctly that 1 dog record 
has been found...

If I alter the controller like so:

from gluon import *

@auth.requires_login()
def testStarter():
    """This is to explore SQLFORM.smartgrid capabilities"""
    grid = SQLFORM.smartgrid(db.owner,linked_tables=['dog'])
    return locals()

that is, if I remove the fields=[db.owner.name] argument, everything (both 
owner and dog grids) works ok!

??????

Thank you all in advance

Tom.

P.S.: OS: Windows XP professional, SP3
        web2py version: 2.4.6-stable+timestamp.2013.04.06.17.37.38 (Running 
on Rocket 1.2.6)
        MySQL version: 5.1.41 from xampp 2.5.8

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to