close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Overwriting field field content

Thread began 7/16/2012 11:34 am by info4753 | Last modified 7/26/2012 1:31 pm by Andrew Read | 788 views | 5 replies |

info4753

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

info4753

Thx Jason.

Sign in to reply to this post

Andrew Read

Sticky please!

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? :)

Sign in to reply to this post

Jason ByrnesWebAssist

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:
<?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
?>
Sign in to reply to this post

Andrew Read

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

Sign in to reply to this post

cal114936Beta Tester

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

cal114936Beta Tester

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

Attached Files
content1_update.zip
Sign in to reply to this post

cal114936Beta Tester

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...