Overwriting field field content

I've generated DataAssist pages containing a file field. It looks like that when I update the form without selecting a new file in the update page, the content of the file field will be cleared by standard. Is this correct? How can I avoid this?

add a hidden form element to your update page, Bind the initial value of the hidden element to the File Column of the recordset on the update page.

In the Upload File Behavior, Bind the Default File Name setting to the hidden form element.

Thx Jason.

Every time I add a file field, I have to remind myself what the issue on updates is (I can remember that there IS one...!) ;) Can this either be a sticky, or is this something that the wizard can (and should) be doing for us already? :)

The wizard in Data Bridge 1.0.6 should be doing this for you already.

I have jsut tested this and the wizard is correctly setting the default file setting. It is using the file column from the Recordset on the update page, but this should be working as expected.

<?php

// WA_UploadResult1 Params Start

$WA_UploadResult1_Params = array();

// WA_UploadResult1_1 Start

$WA_UploadResult1_Params["WA_UploadResult1_1"] = array(

    'UploadFolder' => "",

    'FileName' => "[FileName]",

    'DefaultFileName' => "".($row_WADAps3_products["ProductThumb"])  ."",

    'ResizeType' => "0",

    'ResizeWidth' => "0",

    'ResizeHeight' => "0",

    'ResizeFillColor' => "" );

// WA_UploadResult1_1 End

// WA_UploadResult1 Params End

?>

Super, I wasn't sure if this had been fixed or not. Glad to hear it is. :)

Like I said in the update delivery post... great work! :D

In the update record behavior, do you use the hidden field?

no, in the update record behavior, you bind the file column to the Server File Name binding.

Jason,

Would you mind taking a look. I have it binding to the server file name and it is still not updating the database. I've attached the file.


Jack

I believe it was caused by the update record code being before the upload file code. I re-ordered it and it appears to be working now.