[web2py] Re: display a stored .jpg during a record list or update

[mdipierro]

If you are looking for a preview of the uploaded images when editing a
record you can to do

form = SQLHTML(....,upload=URL(r=request,f='download'))

On May 24, 10:52 am, NetAdmin <mr.netad...@gmail.com> wrote:
> I'm a bit confused.
>
> During an edit or listing of all books,
> how can I display the .jpg file that is
> stored in the field named coverblob ?
>
> I can only see the blob field contents
> when using appadmin.
>
> Thanks!
>
> ==========   db.py  ==========================
>
> db.define_table( 'tbbooks' ,
>   SQLField('booktitle' , 'string', length=20),
>   SQLField('cover', 'upload', uploadfield='coverblob'),
>   SQLField('coverblob', 'blob')
> )
>
> ======== default.py  ==========================
>
> def index():
>   #
>   #   select all books
>   #
>   recs = db().select(db.tbbooks.ALL,orderby=db.tbbooks.booktitle)
>   return dict ( recs = recs )
>
> def editrec():
>   #
>   #  edit record 1
>   #
>   form = SQLFORM( db.tbbooks, 1 )
>   #
>   if form.accepts(request.vars, session):
>     response.flash = 'Done!'
>   #
>   return dict ( form = form )
>
> def insrec():
>   #
>   # insert a new record
>   #
>   form = SQLFORM( db.tbbooks )
>   #
>   if form.accepts(request.vars, session):
>     response.flash = 'Done!'
>   #
>   return dict ( form = form )
>
> ==================================