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 )

==================================

Reply via email to