Delete file from server

I have a dataassist type results page for uploaded pdf documents, and on the tabular data I have a delete button on each row.

On click, this populates the WADADeleteRecordID hidden field and launches the delete popup. - works fine.

On deletion, I also want to remove the file itself, as well as the database record, so I added the delete file server behavior

I have edited the onclick behavior of the button so that it also sets the value of a new hidden field WADADeleteFileName with the filename from the recordset, but it will not populate the field.

page attached

Have you tried deleting the file first before the record?

Hi Chris.

It isn;t the order which is causing me the issue.

If I change the hidden fields to text fields, I can see that the UploadID box is updated from the onclick event, but the FileName is not.

in the onclick event you are using the Description column:

document.getElementById('WADADeleteFileName').value=<?php echo ($row_rsuploads['Description']); ?>;

shouldn't that use the File Name column?

document.getElementById('WADADeleteFileName').value=<?php echo ($row_rsuploads['DocumentFileName']); ?>;

Yes, it should, I tried documentfilename, then description because I couldn't get documentfilename to work.

Strange thing I discovered, if the description field is numerical, it copies Ok, if it contains any alpha characters, it doesn't !

since there aren't any quotes around the value being passed, it is assumed by JS to be numeric.

change:

document.getElementById('WADADeleteFileName').value=<?php echo ($row_rsuploads['DocumentFileName']); ?>;

to:

document.getElementById('WADADeleteFileName').value='<?php echo ($row_rsuploads['DocumentFileName']); ?>';

That's it.

Without the quotes, it fails, with the quotes it works !

Thanks Jason

yeah, when using a text for a variable in JS (PHP too) you need to include quotes:

JS:

var foo = 'bar';

PHP

$foo = 'bar';

no quotes are needed when using a numeric value:
JS:

var foo = 123';

PHP

$foo = 123;

oops, meant to give 5 stars, but can't edit the rating.

That's OK, I'll take 4 1/2 ;)