Please remove this post I have already posted it
Τη Παρασκευή, 12 Απριλίου 2013 9:36:26 π.μ. UTC+3, ο χρήστης
t_gle...@yahoo.com έγραψε:
>
> #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.
