[web2py] Re: db query that returns a list of field values

That was it, I needed to pull the content using row.URL. Thank you for the prompt response. On Monday, August 10, 2015 at 11:52:26 AM UTC-4, Massimo Di Pierro wrote: > > yes a Row (a record is a dictionary) but you can do: > > def make_run(): > siteList = [] > rows = db(db.websites).sele

[web2py] Re: db query that returns a list of field values

yes a Row (a record is a dictionary) but you can do: def make_run(): siteList = [] rows = db(db.websites).select(db.websites.URL).as_list() for row in rows: siteList.append(row.URL) return locals() or def make_run(): rows = db(db.websites).select(db.websites.URL).as_l