Are you looking for a Row object when you aren't using the DAL but are
instead using your own SQL? It isn't quite a Row object, but if you
are trying to use db.executesql() there is a new third option
(as_dict) that if True will at least return the resultset as a list of
dictionaries keyed off of the fields included in your sql select
statement. This will make things a bit easier since then you can use
{{=row['fieldname']}} instead of {{=row[0]}} which at least makes
things more readable. Not sure if this helps you or not.
#db.executesql(sql, args, as_dict)
results = db.executesql("SELECT field1, field2 FROM table WHERE field3
= ?", (field3_value), True)
{{for row in results:}}
{{=row['field1']}} and {{=row['field2'}}
{{pass}}
~Brian
On Dec 17, 6:14 pm, Mengu <[email protected]> wrote:
> Hi,
>
> I would like to learn how can I return Row objects with _execute
> (query).
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
