record = db.mytable[1]
filename, file = db.mytable.myfile.retrieve(record.myfile)
A('%s'%filename, _href = URL(request.application, 'default',
'download', args = record.myfile))i read the answer on this mailing list and i provided it to others like 50 times, this should go into the FAQ of web2py
