I am now experimenting with uploading files to the database but have not been successful and have some questions:
1) Field('file','upload', uploadfield='fileblob'), I understand this is supposed to create the fileblob field automatically. However it does not seem to do this for me. Does it not work with sqlite? 2) I have added fileblob to my model explicitly and when i display a SQLFORM it displays a button and lets me choose a file. However when I submit then the record is redisplayed and the file does not seem to be shown nor is it in the database. I don't see what I am doing wrong. Is there an example somewhere that shows file uploads to the database working? 3) If I use a custom form which loops through form.custom.label then it fails at self.custom.widget["fileblob"] saying it is a key error. Do I have to explicitly miss out the fileblob fields within my custom table?