Johann, Does grid work if you comment out that left join?
On Dec 13, 5:37 am, Johann Spies <[email protected]> wrote: > Please help me to understand the behaviour of the following controller. It > receives a name of a table and that table's title-field from a form. > > def lys_vermiste_titels(): > """ > tt = title-field > tabel = tabelname > """ > tabel = request.vars.tabel > tt = request.vars.tt > db[tabel].id.represents = lambda id, row: A(T('check'), > _href = URL(r = request, c = 'default', > f = 'hanteer_vermiste_titels', > vars = dict(id = str(id), tabel = > tabel, tt = tt))) > > query = db.akb_articles.title==None > fields = [db[tabel].id, db[tabel][tt]] > # tb = SQLFORM.grid(query, fields = fields, > # left = db.akb_articles.on(db.akb_articles.ltitle > == db[tabel].ltitle), > # editable = False, searchable = False, create = > False, > # deletable = False) > tb = SQLTABLE(db(query).select( > db[tabel].id, db[tabel][tt], > left = db.akb_articles.on(db.akb_articles.ltitle == > db[tabel].ltitle)), truncate = 150) > lengte = len(tb) > if lengte: > print tb > opskrif = H2(T("Titles in %s which are not in AKB") % tabel) > else: > opskrif = H2(T('All the article titles in %s are in AKB') % tabel) > tb = H3(P(T('No absent titles.'))) > return dict(vorm = tb, opskrif = opskrif) > > 1. If I use the SQLFORM.grid (commented out in this example) in this case: > the fields are all empty although the number of records for the query is > the same as in the second case where I use tb = SQLTABLE which presents the > expected data. Why would this be? > 2. My .represent definition has no effect. I get the bare id numbers in > the view. Why? > > Regards > Johann > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3)
