On Sun, Apr 26, 2009 at 12:14 AM, weheh <richard_gor...@verizon.net> wrote:
>
> Sorry, I wasn't clear. I want to do something like this:
>
> x=db(query0).select(db.table.ALL,orderby=something)
> x.append(db(query1).select(db.table.ALL,orderby=somethingelse))
>
> I get an error message about not being able to append to an SQLRow
> object.

There is no .append() method, nor + operator to SQLRow objects.
Maybe it can solve your problem:

r1 = db(query0).select(db.table.ALL,orderby=something)
r2 = db(query1).select(db.table.ALL,orderby=somethingelse)
my_rows = r1.as_list() + r2.as_list()

So my_rows will be a list of dicts (one dict = one row).

-- 
 Álvaro Justen
 Peta5 - Telecomunicações e Software Livre
 21 3021-6001 / 9898-0141
 http://www.peta5.com.br/

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---

Reply via email to