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

new DA repeat region not working

Thread began 12/11/2018 9:54 am by Sweens | Last modified 12/13/2018 11:34 am by Ray Borduin | 53 views | 5 replies |

Sweens

new DA repeat region not working

I've just updated the old mysql page to mysqli and now the repeat region does not work. I've deleted it and reapplied it several times, without success.

I'm therefore unable to test if the other server behaviours dependent on the repeat region work.

Cheers
Chris

Sign in to reply to this post

Ray BorduinWebAssist

The repeat selection server behavior doesn't effect the number of rows returned by the recordset. That is because it is designed to be used within a repeat region server behavior for nested repeats.

The best solution would probably be to use Repeat Region instead (Webassist->MysQLi->MySQLi Repeat Region)

That would update the number of results returned in the recordset to match the repeat region. Another solution is to update the rows returned in the recordset manually.

That is done in this line:

php:
$rsTopPics = new WA_MySQLi_RS("rsTopPics",$connRoSite_i,1);



To make it return more results you can just change the number at the end to match the number of results you want returned. To return all rows you set the value to zero like:

php:
$rsTopPics = new WA_MySQLi_RS("rsTopPics",$connRoSite_i,0);
Sign in to reply to this post

Sweens

Thanks Ray

I missed that - I just changed the recordset from mysql to mysql_i and hadn't checked.

Now repeating a expected, but the multiple update doesn't work. Again, I have applied it several times to check, without success.

Cheers
Chris

Sign in to reply to this post

Ray BorduinWebAssist

It looks like you still have MySQL update code for your Multiple Update and not MySQLi Multiple Update. Try applying the MySQLi Multiple Update server behavior instead.

Sign in to reply to this post

Sweens

Hi Ray

Have re-applied it, starting from scratch. Still doesn't work.

Cheers
Chris

UPDATE - Just started from scratch again and it works!!

Sign in to reply to this post

Ray BorduinWebAssist

I'm glad it is working now. It can be a bit tricky and converting from mySQL to mySQLi may have some challenges since their are hidden form elements and dynamic field names all working together.

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