If you benefit from web2py hope you feel encouraged to pay it forward by contributing back to society in whatever form you choose!

  • 0
    nate  11 years ago

    "invalid table/column name "file" is a "ALL" reserved SQL keyword"

    is there an easy way to fix this, please

    replies (1)
    • josedesoto 11 years ago

      I think you are getting the error in the model because the Field with the name: file is a reserved SQL keyword. try to change it, for example: f_file. After that in the controller you have to change it when you are calling to the field, for example:

      aux=db.files.f_file.store(fileApp, filename) db.files.insert(f_file=aux,title=filename)

Commented on:

Brief explanation how to upload files using html5 and jQuery

Hosting graciously provided by:
Python Anywhere