close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Uploading file and saving filename to database

Thread began 7/31/2013 9:31 pm by Lon Winters | Last modified 9/06/2013 5:34 am by Lon Winters | 400 views | 4 replies |

Lon WintersBeta Tester

Uploading file and saving filename to database

Like most of the questions I post here, this is another where I'm in the process of figuring it all out but just want to make sure I'm not missing anything. And even if it doesn't seem like it, I do do my home work and read the documentation and search the forum.

I applied a file field to an update page, replacing a text field that contained the image name. I kept the field name the smae and did not change the update record behavior. This actually worked as I was able to upload and replace the file. But when I went to update another item on the form it deleted my image name from the database. So after my research I made the following changes and so far so good. Please confirm that I have everything correctly cofigured.

1. In the upload Files behavor, the File field is bound to the File Field form element
2. The default file is bound to the column from the recordset that contains the filename
3. In the Data Assist update behavior, the database column is bound to the "Server File Name". found in the section called "Upload Files (myFileFieldName). I imagine the other options in this section are used for whatever they represent and what may be written to other database fields if needed, but for now I"m keeping it simple.

Sign in to reply to this post

Jason ByrnesWebAssist

you should have a hidden form element in your form, bind the value of the hidden form element to the file column in your recordset.

in the upload file behavior, bind the Default file field to the hidden element.

Sign in to reply to this post

msummers194171

Jason, I'm a little confused by this. My form has a file field and a hidden field. The contents of the hidden field will be inserted into the database. On the page, the sequence of functions is:

1. Upload image
2. Write the record to the database
3. Populate the hidden field

So, the record is written to the database before the hidden field is populated so that its value would appear in $_POST. What am I missing?

Sign in to reply to this post

Jason ByrnesWebAssist

is this an insert page or update page?

The hidden field is only needed on the update page.

On an update page, the hidden field is used to store the name that exists in the database for that record already, so that if no file is uploaded, the default file name will use the already existing one.


on an insert page, you need only the file filed.

in the insert record behavior, bind the file column to the Wa Uploaded Files (File Field Name) -> Server File name variable.

Sign in to reply to this post

Lon WintersBeta Tester

Mine was working, or so I thought, by using the steps I had in the original post and without the hidden field. This is an update page. I noticed that the file name being written to the database duplicated the file extension, such as "imagename.jpg.jpg"

So, first I added the hidden form element. I didn't think I needed that as I had bound the default file in the Upload behavior directly to the file column from the recordset. With the hidden form element, I can visualize the process and I know it works. Even though the direct bind to recordset also seemed to work, I still can't visualize the process with that method. So I'm keeping the hidden field.

Still, it didn't solve my duplicate extension problem. Not by itself anyway. Now that I had the hidden field, and the original file name safely bound to a form element, it just made sense to change the update record behavior to the file field, and not the server file name like I had originally.

Works great now! Now I just have to go back to my insert page which also contains and upload and see what crazy things I did on that one.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...