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

Multiple row update question

Thread began 12/17/2012 12:10 pm by CraigR | Last modified 12/19/2012 2:00 pm by Jason Byrnes | 462 views | 5 replies |

CraigRBeta Tester

Multiple row update question

I have a member registration form which allows multiple email addresses to be associated with an account.

I have a repeat selection loop on the data insert form with 3 iterations so that up to 3 addresses can be added to a joined table using the multiple record insert behavior.

This works fine, but on the update form, i get only the the number of rows in the recordset returned, so, for example, if one address was entered for a member, only one row is returned.

i would also like to display 3 rows on the update table, so there is an opportunity to add additional email addresses.

Make sense ?

Sign in to reply to this post

Jason ByrnesWebAssist

on the update page, set the repeat selections to use 3 instead of the recordset.

Sign in to reply to this post

CraigRBeta Tester

hi jason,

i tried that, but i get the first row in my recordset returned 3 times.

if this isn;t what is expected, i'll try again

Sign in to reply to this post

Jason ByrnesWebAssist

use 3 for repeat selection, but then add a repeat region around it to loop through the recordset.

Sign in to reply to this post

CraigRBeta Tester

Thanks Jason.

I did try the nested loop, and appearance wise, got it looking ok, but then realised that, because my contact details are in a linked table, i need to use insert server behavior on any new data.

Went back to a repeat region and added an extra field for any additional data and applied insert behavior to this

Sign in to reply to this post

Jason ByrnesWebAssist

Ok, glad to hear you have it working.

Sign in to reply to this post

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