I use executesql, but I don't now how work with resulte in form
controllers.
for example work with procedure
test/controllers/default.py
def index():
return dict(org=db.executesql('select name,code,empcnt from
org_chart(100) where empcnt<>2'))
test/default/index
org:Max
100
1244
Mike
102
8
result in one column
There is problem fieldnames procedures and views. How work with result
executesql in controller?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
