file upload

I have created an insert form to upload mp3 files. The form contains the details of the mp3 and the mp3 is to be oploaded into a directory on my server. But seems not to do it. if the file upload part is removed, it works but including it inserts no record on my database and folder. I used the error detection script to troubleshoot it but no feedback. Please see attached

You are using the dreamweaver native insert behavior which will not work with file upload.

you need to use the Data Assist insert record behavior instead.


to add the data assist insert record behavior, open the server behaviors panel, click the plus button and select WebAssist -> Data Assist -> Insert -> Insert Single Record.

for the column that you wish to store the uploaded file name, click the lightning bolt icon and select the Uploaded Files(File Field Name) -> Server File Name binding. for the other columns, select the corresponding form element binding.

Thanks Jason, I have rectified it but now the data are not inserted into the database. Please see attached file

I'll need to troubleshoot directly, see the private message section.

Hi Jason, I was able to sort it out. Once I uploaded the files onto the web server it works well as expected. Thanks.

However with the download side, I have the following issues with the downloaded files.
It is the same mp3 file that is downloaded in all instances, when user selects the download button in each record. the downloaded mp3 file is always the most current file in the database.

Secondly, there is also a section in my download page (listen), where user can listen to the mp3 files (that is, play the mp3 without downloading it). I used a simple <audio controls></audio> html tag , it works for the first record in the database but for the other records in the repeated region it does not work, though displayed. Please see the site:

for the download, you have one form around the entire results page.

you need to remove that form, then for each results pod, add a form with the download button and a hidden element, in the hidden element, set the value to the file name column from your recordset.

in the download behavior, set the download file name to use the hidden element from the results page.


as for the file player not working, I cannot support a 3rd part MP3 player.