Re: Can you Upload a file and update a db on 1 form?

You can not use the FP File Upload component and submit to the database:
http://support.microsoft.com/default.aspx?scid=kb;en-us;830324&Product=fp2002

You will need to create a form, then submit it to the database, then in the next step in the process
allow the user to upload a file and then update the record that was created in the first step, then
will require custom coding and a ASP upload component, such as ASPUpload from
http://www.aspupload.com

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Lazlo" <Lazlo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05F9BB89-9B69-4130-9B53-9195A56BC7B1@xxxxxxxxxxxxxxxx
> We are our own host so that's not the problem. I have been trying to do the
> file upload and database on the same form. Either the file upload works or
> the db update works not both. We are trying to make it easier for the end
> user to upload a newsletter and update the database with the same form. We
> also have ftp capability for the site. Can you use ftp on the same form as
> the update for the db? If so could you point me in the best direction. Our
> site is a homebrew site. We plan to use the fileload and database update
> strategy for our beer recipes also. Any help is greatly appreciated.
> --
> Lazlo
>
>
> "Thomas A. Rowe" wrote:
>
>> Check with your web host to see if they offer a ASP upload component.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Lazlo" <Lazlo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:6A59931C-C073-4205-AAD2-96C397F75ACB@xxxxxxxxxxxxxxxx
>> > 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.
>> >
>> > --
>> > Lazlo
>>
>>
>>


.

Relevant Pages

  • Re: Can you Upload a file and update a db on 1 form?
    ... Check with your web host to see if they offer a ASP upload component. ... Thomas A. Rowe (Microsoft MVP - FrontPage) ... security update, then there is usually no charge for the call. ... > the date the form was published, display name and newsletter path. ...
    (microsoft.public.frontpage.programming)
  • Re: I lose data, when I try to save a loaded DataTable on the click of another button in an asp.net
    ... that allows for the upload of an excel sheet into the database. ... I have an upload button and a save button. ... which is bound to a GridView for previewing before ... protected void Upload_Click(object sender, EventArgs e) ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Im about to commit matrimony (now with link)
    ... Keep tweaking the CV and upload new versions if the old ... with Wboserve yesterday, but their upload pages were borked. ... database and run several different filters against it. ... There's still an awful lot of COBOL code around and universities don't teach ...
    (uk.rec.sheds)
  • Re: form to email document
    ... >> append the Session ID for that user Session to the file name. ... >> name uploaded.This can come from a simple text file or a database. ... >>> I was hoping for something like the procedure used to upload a form, ...
    (microsoft.public.frontpage.programming)
  • Re: Listbox controls
    ... When the first time I upload the file into the database, ... 'Dim oConnection As New OleDbConnection ... Dim strFileUploadQuery As String = "INSERT INTO Attachments ...
    (microsoft.public.dotnet.languages.vb)