<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.

Reply via email to