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

Text destroyed on update record

Thread began 4/15/2019 10:53 am by Robert Crespo | Last modified 4/16/2019 12:16 am by Ray Borduin | 29 views | 10 replies |

Robert Crespo

Text destroyed on update record

Dear WebAssist,

I am having a persistent problem with losing data in my database after clicking the update button on a DataAssist built page. For example, a paragraph of text contained in one of my product table rows get shortened to just one sentence. This is very problematic, because, while I can create a new record, any changes to most of the rows in my table gets partially destroyed when I have to update the record. As you can see, this is a situation that I CANNOT live with. Interestingly enough, there is no text or data loss in the table row where I am using the WebAssist HTML editor interface. Any help you can provide to offer a solution to this data destruction issue will be most welcome.

Thank you,
Robert Crespo

Sign in to reply to this post

Ray BorduinWebAssist

I'll need to reproduce the error to debug the cause. This is not standard behavior, so I don't know what might be making it happen. I'll need FTP access and a URL with steps to reproduce the issue. That will allow me to add code to see what is happening and come up with a fix.

Sign in to reply to this post

Robert Crespo

Originally Said By: Ray Borduin
  I'll need to reproduce the error to debug the cause. This is not standard behavior, so I don't know what might be making it happen. I'll need FTP access and a URL with steps to reproduce the issue. That will allow me to add code to see what is happening and come up with a fix.  
Sign in to reply to this post

Ray BorduinWebAssist

I can't seem to access the site via FTP. However, even if I could, I can't seem to reproduce the problem. I'm inserting multiple sentences into the description field and haven't had an issue. Maybe it has something to do with the specific content you are entering?

I'll need FTP access and steps to reproduce since both don't seem to be working for me currently.

Sign in to reply to this post

Robert Crespo

Ray, please see the private message.

Sign in to reply to this post

Ray BorduinWebAssist

I'll need help reproducing the issue. It looks like the blog I created still has multiple sentences and isn't truncated on the update page. Where should I be looking for the issue.

Please provide the exact text I should enter to see the problem and the steps and location I should be looking in order to see the issue. I'm missing something, so I just need help to see the problem.

Sign in to reply to this post

Robert Crespo

Ray, when I copied the text from description of another blog post I recreated the issue. Please copy the contents of the previous blog post in the Desc field of the test blog post and you should see this happen. After you update the page one or two times the text of the desc area gets clopped off.

Sign in to reply to this post

Ray BorduinWebAssist

The issue was with having a double quote in the description. This issue has been fixed in recent versions of the rsobj.php file. You were using a very old version (v2.6). I've updated it to v2.26 and I believe that will fix this problem.

Sign in to reply to this post

Robert Crespo

Ray,

Thank you very kindly for updating the rsobj.php file to the latest version. I will be sure to download a backup on my local server. I tested the update page multiple times and it looks like the page has been fixed once and for all. A hearty thanks!

Sign in to reply to this post

Ray BorduinWebAssist

You need to add the ,false argument to the getColumnVal() function to allow it to display html. Just go to that page and find the line that has:

$RecordsetName->getColumnVal("ColumnName")

and change it to:
$RecordsetName->getColumnVal("ColumnName",false)

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...