Hello, web2py world.
I'm new to web2py and web development.
The index page displays a list of equipment type and has a link to a list
of equipment of this type.
The index works fine but using the link redirect to the index page.
There is no error message.
When I replace the index code by the show_flexlist code, the equipment list
is displayed
I use MSSQL server and use the profiler to see what is the SQL command pass
to it, but there is none.
I'm log in when I make a test.
I'm sure stupid but want to understand how to be cured.
Best regards
Yann
default control
@auth.requires_login()
def index():
db.type_article.articlename.writable=False
db.type_article.id_narval.writable=False
db.type_article.writable=False
response.flash = T("Bonjour ")+auth.user.username
myquery=(db.type_article.id==db.articles.condi_id)&(db.articles.depot_id
==auth.user.id_depot)
myfields={db.type_article.articlename,db.type_article.id}
myheaders={'type_article.articlename':T('Type article'),'Type_article':
'ID'}
default_sort_order=[db.type_article.articlename]
type_articles=SQLFORM.grid(query=myquery
,orderby=default_sort_order
, deletable=False
,editable=False
,details=False
, maxtextlength=64
, paginate=25
,create=False
,fields=myfields
,headers=myheaders
,field_id=db.type_article.id
,groupby=db.type_article.articlename|db.
type_article.id
,links = [lambda row: A('View flexi list',
_href=URL("default","show_flexlist",args=[row.id]))])
#,fields=fields,headers=headers
return dict(message=T('Welcome to Web Braid stock!'),type_articles=
type_articles)
@auth.requires_login()
def show_flexlist():
response.flash = T("valeur ")+request.args[0]+' /' +str(auth.user.
id_depot)
myquery=((db.articles.condi_id==request.args(0, cast=int))&(db.articles.
depot_id==auth.user.id_depot))
myfields={db.articles.cod_ref,db.articles.conteneur,db.articles.dossier,
db.articles.id}
myheaders={'articles.cod_ref':T('Flexi
Number'),'articles.conteneur':T('Conteneur
Number'),'articles.dossier':T('Braid reference'),'articles.id':'ID'}
default_sort_order=[db.articles.cod_ref]
flexlist=SQLFORM.grid(query=myquery
,orderby=default_sort_order
, deletable=False
,editable=False
,details=False
, maxtextlength=64
, paginate=25
,create=False
,fields=myfields
,headers=myheaders)
#,fields=fields,headers=headers
return dict(message=('test'),flexlist=flexlist)
default/show_flexlist.html
{{extend 'layout.html'}}
{{block header}}
<center style="background-color: #428bca; color:white; padding:30px">
<h1>/{{=request.application}}
</center>
{{end}}
{{if 'message' in globals():}}
<h2>{{=message}}</h2>
{{pass}}
{{=flexlist}}
default index
{{extend 'layout.html'}}
{{block header}}
<center style="background-color: #428bca; color:white; padding:30px">
<h1>/{{=request.application}}
</center>
{{end}}
{{=A('View flexi list',_href=URL("default","show_flexlist",args=15))}}
{{if 'message' in globals():}}
<h2>{{=message}}</h2>
{{pass}}
{{=type_articles}}
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
