close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Insert unique id in repeat section

Thread began 1/03/2018 1:59 pm by eric284736 | Last modified 1/03/2018 2:56 pm by Ray Borduin | 81 views | 5 replies |

eric284736

Insert unique id in repeat section

Hi Ray,

I am trying get a mysqli repeat section to insert the unique id but it is only inserting the first id in the results. I have the page attached. What am I missing?

thx
Eric

Sign in to reply to this post

Ray BorduinWebAssist

I'm not sure exactly what you are trying to do and where it is failing.

Are you submitting the first form or the second form? Which column has the wrong value after the insert? What value does it have and what value would you expect it to have?

Sign in to reply to this post

eric284736

It should insert from either form. One is the winner, the second is the guest of the winner. It should be pulling the actID from the rsSchedule records and inserting that into the OrdersDetail table. It is only inserting the first record in the recordset instead of the actual record you select.

See PM

Sign in to reply to this post

eric284736

see pm

Sign in to reply to this post

Ray BorduinWebAssist

Each row has the same actID and you are filtering based on the actID for the recordset that controls the insert.

You would want to pass the id and filter a recordset with the id column in order to insert the correct row. It looks like you have that value in a hidden form element named "id", but you never use it to filter the recordset.

One of the problems is that you are inserting from the same recordset you are using to display. That can be tricky because you are displaying multiple rows and inserting just one.

I'd start by creating a new rsInsert recordset that you filter with the hidden id and the actID that is passed in the url and then use that recordset for the insert. It would only return one row, and it would be the right one that you want inserted.

Sign in to reply to this post

eric284736

Got it! Thanks Ray!!

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