The following code results in an error: "Query not supported":
query = db.akb_l1_journal.jnl_id ==db.akb_journals_mentioned_in_sa_list.
jnl_id
fields = [db.akb_l1_journal.title, db.akb_l1_journal.abbreviation,
db.akb_l1_journal.issn]
form = SQLFORM.grid(query, fields = fields,
groupby=db.akb_l1_journal.id|db.akb_l1_journal.title
|db.akb_l1_journal.abbreviation|db.akb_l1_journal.issn, orderby = db.
akb_l1_journal.title,
formstyle= 'divs', deletable = False, editable =
False,
maxtextlength = 150
)
print db._lastsql
But it generates the following valid sql which successfully executes when
run in psql or pgadmin3:
SELECT akb_l1_journal.title, akb_l1_journal.abbreviation,
akb_l1_journal.issn, akb_l1_journal.id FROM akb_l1_journal,
akb_journals_mentioned_in_sa_list
WHERE (akb_l1_journal.jnl_id = akb_journals_mentioned_in_sa_list.jnl_id)
GROUP BY akb_l1_journal.id,
akb_l1_journal.title,
akb_l1_journal.abbreviation,
akb_l1_journal.issn
ORDER BY akb_l1_journal.title;
So what is the problem?
Regards
Johann
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
