Try something like this:.....in models/db.py:
db.define_table('org_chart', SQLField('name'),
SQLField('code', 'integer'),
SQLField('empcnt', 'integer'),
# migrate=False # if web2py should NOT CREATE or ALTER table
)
......in controllers/default.py:
def index():
orglist = db().select(db.org_chart.empcnt != 2)
return dict(orglist=orglist)
......in views/default/index.html:
{{extend layout.html}}
{{=TABLE(*[TR(*emp) for emp in orglist])}}
This should help you get started.
Regards,
Yarko
On Thu, Mar 12, 2009 at 2:19 AM, shuval <maxshuva...@futcom.ru> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
