close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Help on an multiple update with insert behavior

Thread began 5/14/2013 11:50 am by danielsebas | Last modified 5/22/2013 12:24 pm by Jason Byrnes | 2529 views | 11 replies |

danielsebas

Help on an multiple update with insert behavior

Hi, I am making a web page where someone registers his music band. for this I made the tables; users, band, many and item. For insert page I have a simple insert for the band table and a multiple insert for the many table the many table will store the values that refer from the item table wich are not required in the form (optional) so the user can insert the six items or just a few. Until then everything works ok, the only thing that I cannot accomplish is to retain the values entered in the form for the multiple insert if the form doesn't pass the server validation.

The other issue comes in the update page. I will like the page to see like the insert page with all the fieds and in the multiple update to show the six items even if some of them haven't been inserted in the insert page so if the user whants to update his info, he can change the one he first inserted and also insert the fields that he didn´t insert at the beggining. The issue is with the multiple update to convert it also in a multiple insert and to show the option to enter the new values and to update the old ones if there is any.
Can I accomplish this with WA extensions and how can I do it?
Thank you for your help.

Sign in to reply to this post

Jason ByrnesWebAssist

it sounds like you should be using the manage relational table behavior instead of the multiple update.

Sign in to reply to this post

danielsebas

Hi Jason, thank you. I'm trying to use that behavior but I don't know how to achieve what I want, the update page keep showing only the values that I have in the database and not all the six options from the items table.

Sign in to reply to this post

Jason ByrnesWebAssist

the rsmany recordset is set to filter records based on the UserId session.

to show all of the item in the many table, you should not be filtering the recordset.

Sign in to reply to this post

danielsebas

Thank you Jason, but since this will be an update page, how can I bind the records that the user inserted previously?

Sign in to reply to this post

Jason ByrnesWebAssist

the MRT behaviors should do that automatically.

see the tutorial for using the Manage relational Table behavior:
http://www.webassist.com/community/tutorials/view_tutorial.php?tid=25

Sign in to reply to this post

danielsebas

Hi Jason I followed the tutorial but I can't apply it in my update page, instead of a check box I have a text field and I cannot make my data to display correctly.

Sign in to reply to this post

Jason ByrnesWebAssist

Originally Said By: danielsebas
  Hi Jason I followed the tutorial but I can't apply it in my update page, instead of a check box I have a text field and I cannot make my data to display correctly.  
Sign in to reply to this post

danielsebas

Private message

Sign in to reply to this post

Jason ByrnesWebAssist

Originally Said By: danielsebas
  Private message  
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...