<td>{{=A(row.doc_filename, _href=URL('show', args=row.doc)) if row.doc else 'no attached file'}}</td>
Anthony On Wednesday, April 6, 2016 at 11:39:25 AM UTC-4, Andrea Marin wrote: > > Hi all, > > I have a db table where I store some information and sometime a file like > *.doc or *.pdf > This is my model file > > db.define_table('pratiche', > Field('nome', requires=IS_NOT_EMPTY()), > Field('descrizione', 'text', requires=IS_NOT_EMPTY()), > Field('data_creazione', 'date'), > Field('doc_filename'), > Field('doc', 'upload')) > > I have a controller to insert, list and show the data into the table > default.py > > def index(): > rows = db(db.pratiche).select() > return locals() > > @auth.requires_login() > def create(): > db.pratiche.data_creazione.default = request.now > db.pratiche.data_creazione.writable=False > db.pratiche.data_creazione.readable=False > """ > record = db.pratiche(request.args(0)) or redirect(URL('index')) > url = URL('download') > form = SQLFORM(db.pratiche, record, deletable=True, > upload=url) > if request.vars.image!=None: > form.vars.doc_filename = request.vars.doc.filename > if form.process().accepted: > response.flash = 'form accepted' > elif form.errors: > response.flash = 'form has errors' > return dict(form=form) > """ > > form = SQLFORM(db.pratiche).process() > if form.accepted: redirect(URL('index')) > return locals() > > def show(): > pratica = db.pratiche(request.args(0,cast=int)) > return locals() > > def download(): > return response.download(request, db) > > And I have a view to show the data index.html > > {{extend 'layout.html'}} > > <h2>Pratiche</h2> > <table class="table"> > <tr> > <th>Nome pratica</th> > <th>Allegati</th> > <th>Data Creazione</th> > </tr> > {{for row in rows:}} > <tr> > <td><a href="{{=URL('show', args=row.id)}}">{{=row.nome}}</a></td> > <td><a href="{{=URL('show', args=row.doc)}}">{{=row.doc}}</a></td> > <td>{{=row.data_creazione}}</td> > </tr> > {{pass}} > </table> > > My problem is that in the view index.html i show row.doc value that is > retrive from db but is not alway set. > How can I configure a if statement to say > if "there is the upload file" show the name > else "show label no attached file" > > Thank a lot. > -- 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.