How do you update a db and upload a file on the same form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a database that keeps track of our newsletters. It's only fields are
the date the form was published, display name and newsletter path. The
database serves as pointer and a way to sort the newsletters and to search
for them. I would like to know how to use 1 form to both update the database
fields and to also upload the newsletter from the author. We also have ftp
capability on our site. I want the db update and the file upload to be as
simple as possible for our newsletter writer. Thank you in advance.
 
I think you can use the "Upload FIle" field in your form, which submits the
*file path* to the DB and uploads the file to the _private or other folder
as normal.

You would then use the results wizard to display the database contents, and
create a link to the newsletter file, based on the data in the 'file' field
in your database.

If you use FTP in any form, you risk breaking the frontpage extensions which
will render the upload file component useless, unless you use a third party
application in the scripting language for your server.
 
Back
Top