It's screaming invalid literals anyway. Think I'll skip it. On Thursday, August 30, 2012 5:07:19 PM UTC-4, Niphlod wrote: > > right doc location. executesql is a method of dal, so click here and there > and you'll end up at > http://www.web2py.com/examples/static/epydoc/web2py.gluon.dal.DAL-class.html#executesql > > On Thursday, August 30, 2012 11:00:30 PM UTC+2, Mike Girard wrote: >> >> Sorry, didn't mean to have people running errands for me. Where is the >> docstring? Was poking around here >> http://www.web2py.com/examples/static/epydoc/index.html and couldn't >> find what I was looking for. >> >> Too much newbieness i know: Python AND Web2py. >> >> On Thursday, August 30, 2012 4:56:09 PM UTC-4, Anthony wrote: >>> >>> On Thursday, August 30, 2012 4:31:37 PM UTC-4, Mike Girard wrote: >>>> >>>> So today's announcement of the new release included a suggestion that >>>> an executesql result can be returned as Rows. If this is true, can I see a >>>> usage example? A little puzzled by 'fields=,columns='? >>> >>> >>> db.define_table('person', Field('name'), Field('email')) >>> db.define_table('dog', Field('name'), Field('owner', 'reference person' >>> )) >>> db.executesql([SQL code returning person.name and dog.name fields],fields >>> =[db.person.name, db.dog.name]) >>> db.executesql([SQL code returning all fields from db.person], fields=db. >>> person) >>> db.executesql([SQL code returning all fields from both tables], fields=[ >>> db.person, db.dog]) >>> db.executesql([SQL code returning person.name and all db.dog fields],fields >>> =[db.person.name, db.dog]) >>> >>> Here's the docstring: >>> >>> Added 2012-08-24 "fields" optional argument. If not None, the >>> results cursor returned by the DB driver will be converted to a >>> DAL Rows object using the db._adapter.parse() method. Thisrequires >>> specifying the "fields" argument as a list of DAL Field objects >>> that match the fields returned from the DB. The Field objects >>> should >>> be part of one or more Table objects defined on the DAL object. >>> The "fields" list can include one or more DAL Table objects >>> inaddition >>> to or instead of including Field objects, or it can be just a >>> single >>> table (not in a list). In that case, the Field objects will be >>> extracted from the table(s). >>> >>> The field names will be extracted from the Field objects, >>> oroptionally >>> , >>> a list of field names can be provided (in tablename.fieldname >>> format) >>> via the "colnames" argument. Note, the fields and colnames must >>> be in >>> the same order as the fields in the results cursor returned fromthe >>> DB >>> . >>> >>> Anthony >>> >>>
--
