Hey Vasile: Thanks for your answer.. yes.. that I know and that's actually what I'm doing.. but I'd like to use the benefits of doing it with DAL. (cache the queries, security validation for parameters, etc).
regards. On Fri, Jan 28, 2011 at 7:18 PM, Vasile Ermicioi <elff...@gmail.com> wrote: > you always can execute sql > sql_str = 'SELECT * FROM ...' > rows = db.executesql(sql_str) > but your results will not be objects, but an array of arrays or an array of > dicts if you do > sql_str = '''SELECT date, count(foo.items) as total ... ' > rows = db.executesql(sql_str, as_dict = True) > for row in rows: > print row['date'], row['total']
