(I already post this question, but it was deleted in few seconds and no reason was mentioned. I try to repost it, removing formatting and external links... If something is wrong, please inform me :)
I have defined this model: db.define_table('fruits_in_shop', Field('shop_name'), Field('species'), Field('number','integer')) With this kind of record inside: fruits_in_shop.id fruits_in_shop.shop_name fruits_in_shop.species fruits_in_shop.number 1 Mark's shop apple 32 2 Mark's shop pear 22 3 John's Market banana 22 4 John's Market apple 36 I'm looking for a way to show the result as a "pivot table": Shop apple pear banana Mark's shop 32 22 0 John's Market 32 0 22 I often used a mysql trick to get this result, but there is a way to get this result using DAL? Otherwise I suppose to perform sequential queries and store the results in a dictionary. (fruits<-select distict fruit from table; for fruit in fruits: column<-select * from table where fruit=fruit;) In this case, there is a (easy) way to convert that dictionary into a gluon.sql.Rows object? Should I use its __init__ method? --