More details here:
I have 2 tables: shop (2 fields) and enquete (18 fields).
I use an inner join like the one bellow.
'shop.shop_code' is what I call a fully qualified name
'hht_q_1' is what I call a short name. All those names end to be in
_extra and as they contain some unicode, the __str__ method of Rows
fails.
Putting 'enquete' in front of all the names makes the code less
readable, therefore using short names linking to the colums returned
by the inner join.
rows = db(db.enquete.shop_code==db.shop.shop_code).select(
'shop.shop_code', 'shop.shop_name',
'hht_q_1', 'hht_q_2', 'hht_q_3', 'hht_q_4', 'hht_q_5',
'hht_q_6', 'hht_q_7', 'hht_q_8', 'hht_q_9',
'pc_q_1', 'pc_q_2', 'pc_q_3', 'pc_q_4', 'pc_q_5',
'pc_q_6', 'pc_q_7',
)
Please advise.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
