Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › DataAssist pages - Update button deletes record; insert page adds two records

DataAssist pages - Update button deletes record; insert page adds two records

Thread began 5/26/2020 9:37 am by tmcbinc99963 | Last modified 5/27/2020 10:41 am by Ray Borduin | 474 views | 7 replies |

5/26/2020 9:37 am | #1 tmcbinc99963

DataAssist pages - Update button deletes record; insert page adds two records

I've created admin pages using the DataAssist pages plugin.

On the update page, when I change one of the field entries and click 'update', it redirects to the detail page, displays 'this record has been removed, and the record is deleted from the Db.

The insert page also redirects to the detail page and adds two records - one correctly and the other a blank record.

The delete function doesn't delete any records and returns a white results page.

A couple of minor glitches:

The Detail page permanently displays 'this will permanently deleted the record from your Db' warning.

Results page shows an initial cap on all results. Not so on other pages.

Fiies attached, file access in PM

5/26/2020 5:11 pm | #2 Ray BorduinWebAssist

On the update page it appears you updated the form element names but didn't update the Server Behavior to reflect the new names. I fixed this and the update page is working now.

On the details page the delete message was showing because you used a template without an editable region for the <head> contents, so the wizard wasn't able to add some of the necessary CSS. I added it to the body tag and the page displays properly now.

The delete wasn't working on the results page because the connection file was placed too low on the page. I moved it to the top and the delete works now.

The insert page seems to have an updated Insert server behavior that was changed to use SESSION values instead of the posted form values. I updated the server behavior and it appears to be working correctly now.

Did this help? Tips are appreciated...

5/26/2020 6:35 pm | #3 tmcbinc99963

Thanks so much Ray. I was having issues with the editable regions deleting some of my 'head' information, such as includes, css and other.

5/26/2020 6:57 pm | #4 Ray BorduinWebAssist

Yes. Make sure your template has an editable region in the <head>. Dreamweaver adds one automatically when you create a template, so it must have been deleted manually.

Did this help? Tips are appreciated...

5/27/2020 8:15 am | #5 tmcbinc99963

I downloaded all your updated files from the server, then had to make some adjustments to the template. When the detail page was uploaded, the 'this will permanently deleted the record from your Db' warning appears again. It looks like all the css is there, but I don't really know what you added, so I can't be sure.

The results page shows all records both before and after a search is performed. The search is working, because it shows updated records.

The search results show initial caps on all the entries, even though the Db records are all lower case. Where is this coming from?

5/27/2020 9:21 am | #6 Ray BorduinWebAssist

It looks like you re-uploaded an old version of the results and update pages. I re-uploaded the fixed versions and they appear to be working again.

The capitalization is from the prod_admn.css file line 22:

.Sharp_Default {
color: #000000;
font-family: 'Roboto Condensed';
text-transform: capitalize;
}

Did this help? Tips are appreciated...

5/27/2020 10:22 am | #7 tmcbinc99963

After a search, when I leave the results page and return, it still shows the results. I assume this doesn't go away because I'm still within the same session.

I've cleared the browser cache, deleted history and restarted the browser but they still show. What makes this go away?

5/27/2020 10:41 am | #8 Ray BorduinWebAssist

Restarting the browser should clear the search. You could also reset it by doing an empty search. If you want to have a clear search link, it just has to link to the page with ?Search=1 at the end.

Did this help? Tips are appreciated...

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.