File Upload - Posting the Renamed image instead of the original name

I have my file uploads working and if the file name already exists, it correctly adds an increment. ie image 1 = IMG_0415.jpg image 2 = IMG_0415_1.jpg

My problem is that the file name being posted to my database uses the file name being uploaded rather than the renamed file, so both entries have the file name as IMG_0415.jpg.

In the insert record behaviour the field 'filename' has a value of
<?php echo ((isset($_FILES["filename"]))?$_FILES["filename"]["name"]:""); ?>

What should I change that to.

You need to update this to the 'server file name' entry in the 'Upload Files (file1)' binding group. You should be able to do this by selecting the lightning bolt icon.

I used the insert record server behaviour to bind the field as you said. Attached is a screen shot.

But the form is still posting the original file name.

I have also attached the insert page, can you let me know if I have done something else wrong.

Thanks

The page seemed to be setting the filename column to the file extension. I have made an update to the insert that is on this page to use the serverFileName instead to see what the result is for you.

If you get the same bad result you should add in this code just after line 34 on the current page:

die("the server file name is: " . $WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"]);

This will let you know what the server file name value is immediately after the upload occurs.

Hi Eric,

Thank you so much for you assistance.

Initially, your page was doing the same thing, until I added that little piece of code to tell me what the file would be.

I found that it was posting the same file name but looking for another page.

My fault entirely, I forgot to change the form action to refer to the same page as the form instead of a testing page.

I'll remember that in future.

I would also like to add that I was an ADDT user and at first found WebAssist pretty confusing. But after using it for a while I am getting less and less intimidated. Things are working pretty much as I expect.

I would also like to thank you and the other forum helpers for walking me through some sometimes dumb questions.

regards, Peter

I'm glad that you were able to find the culprit, and thanks for the kind words. We are continually working on improving our product offerings and making them as feature filled as possible. Keep an eye out for new versions and products to come.