Trying to delete file from database and server.

You guys have been a great help with every problem I have had and have either given me a fix or a workaround...

I hate to keep bothering but here is a good one.

I have an edit record form, which works perfectly except for the delete file function, There are areas to upload 1 picture and 15 documents on the form.
I have added a check box next to each document field to mark for deletion.
The only one on the field I want you to look at is document 3. 3 is the only one I have changed at this point. UploadResult4 points to document3 since the photo is the first upload.

Attached is the file.
I got the code I used from this post here: http://www.webassist.com/forums/posts.php?id=20042
Just cannot get it to work. I am so close to having this working the way I need it to..
Thanks.

The issue is with the update server behavior. You have that field set to "Ignore" if blank, which doesn't allow you to actually update it to a blank value.

On line 364 you have:
$UpdateQuery->bindColumn("document3", "s", "".$WA_DFP_UploadStatus["WA_UploadResult4"]["serverFileName"] ."", "WA_IGNORE");

I think it would work if you had:
$UpdateQuery->bindColumn("document3", "s", "".$WA_DFP_UploadStatus["WA_UploadResult4"]["serverFileName"] ."", "WA_BLANK");

All I can say is, you rock.. That was it.. well part of it.. Its not deleting it off of the server. Just the database.

I appreciate you guys a ton. I have learned a lot just from my problems that you have helped with.

UPDATE
I updated all the lines so they were WA_Blank and also modified all the other documents so they were all like the document3 line except with the correct document numbers.. Problem is, if I check one for delete and then hit the submit button it deletes ALL of the documents in the database (not from the server). Plus then when change any one of the documents, it updates that document and deletes all the others...


The uploaded file has those lines changed back to IGNORE instead of BLANK. Now I can upload files again. Very confused at this point.

You will have to start by giving the checkbox fields values so you can verify if they have been checked or not. So instead of:
<input name="doc1del" type="checkbox" value="" />

It should be:
<input name="doc1del" type="checkbox" value="1" />

Then you have to set the default image value to the field in the database when they aren't deleting. So for instance on line 52 instead of:
'DefaultFileName' => "".((($_POST["doc1del"] != "delete"))?$_POST["document1"]:"") ."",
you would have:
'DefaultFileName' => "".((isset($_POST["doc1del"]) && $_POST["doc1del"] == "1")?"":$Recordset1->getColumnVal("document1")) ."",

That way if they checked delete it sets the value to blank, otherwise it leaves the existing value from the recordset.

Ok.. We are closer.. 2 problems.
I uploaded 7 documents 1-7.. They show fine in the database. If I choose 1 to delete. say #3 , it deletes all the rest and leaves 3 (but id does delete them off the server as well). Like its is backwards.

The other issue is, if there are files in there, say one on Document 4, and I upload a new ones to Document 1 2 & 3 , they upload fine but delete 4.
I looked and looked but I just dont see it.
Thanks for your help.

Please attach a current version of the page for me to look at.

Sorry Meant to do that.

Try this syntax for the default file name:

'DefaultFileName' => "".((isset($_POST["doc1del"]) && $_POST["doc1del"] == "1")?"":$Recordset1->getColumnVal("document1")) ."",

I forgot that checkboxes that are unchecked won't exist in the post.

I hate to keep bothering you..
That did it for the database part but not deleting the file from the server.. SOOOO close..!
Current attached.

You don't even have the delete file server behaviors applied on the page. You will need to start with that. Apply one for each file. Trigger based on the checkbox and delete the file referenced from the database.