I think you want:
def journal_grid():
query = db.akb_journal.publisher == db.akb_publisher.uuid
fields = [db.akb_journal.title,db.akb_journal.standard_name,
db.akb_journal.issn, db.akb_journal.abbrev_iso,
db.akb_publisher.publisher, db.akb_journal.subject]
form = SQLFORM.grid(query, fields, deletable= False)
return dict(form = form)
or
def journal_grid():
form = SQLFORM.smartgrid(db.akb_journal, deletable= False)
return dict(form = form)
On Aug 24, 9:09 am, Johann Spies <[email protected]> wrote:
> The following is not working. What is the syntax suppose to be?
>
> def journal_grid():
> query = db.akb_journal.publisher == db.akb_publisher.uuid
> fields = [db.akb_journal.title,db.akb_journal.standard_name,
> db.akb_journal.issn, db.akb_journal.abbrev_iso,
> db.akb_publisher.publisher, db.akb_journal.subject]
> form = SQLFORM.grid(db.akb_journal,query, fields,
> deletable= False)
> return dict(form = form)
>
> Errors: query is not iterable and the field list does not have a
> table-object.
>
> Regards
> Johann
>
> --
> May grace and peace be yours in abundance through the full knowledge of God
> and of Jesus our Lord! His divine power has given us everything we need for
> life and godliness through the full knowledge of the one who called us by
> his own glory and excellence.
> 2 Pet. 1:2b,3a
