Cannot bind records

I've created a recordset in MySQLi, but it is ALWAYS limited to one record. It appears on the bindings tab, but only the "insert" button is available at the bottom, as the "bind" button is greyed out. My querry is ALWAYS rewritten to add the "limit 1" commands, even after I delete it. I want to return an array of records so that I can assign the returned records value to variables, but I cannot get more than one value returned. Really frustrating!

In the recordset object it has the number of records passed as a parameter. If you change it from 1 to 0 it will return all results.

I tried that and still only one record appears, and there is no option to bind...

<?php
$rs_location_issue_names = new WA_MySQLi_RS("rs_location_issue_names",$iap_sd_i,0);
$rs_location_issue_names->setQuery("SELECT lp_scalenames.Display_label FROM lp_scalenames");
$rs_location_issue_names->execute();
?>

Also note that they (all 30) appear ok using the TEST button.

What do you mean by bind? What are you trying to do at this point? This recordset should be returning all rows and won't add the limit 1 any more.

$rs_location_issue_names->Results will be the full array returned.

Try writing it to the page with var_dump to see the contents:

<?php 

var_dump($rs_location_issue_names->Results);

?>

OK, I got the dump on the entire array, all 30 records. So I should just address them from their array names and not try to use WebAssist?

I hope to bind a selected record to a variable. It will only return one, and when I try to create a repeating region, nothing at all happens. I viewed the tutorial, but the "bind" button is not functional, whereas the "insert" button works. I was hoping for a list of 30 records in an array form. Is that just not possible? I should at least be able to get a "repeating region" shoulnd't I?

Yes, the MySQLi repeat region should work to show all records. What happened when you tried. Can I get a copy of the page you are working on to review?

I cannot even get a dialog for repeat region now. Here is the page. If I am way off base, I don't mind paying the fee for special help. I followed the tutorials, but cannot get the same screens. I took lots of junk out to make it simple for you to see.
Thank you for your help.

Neill

It looks like your repeat region got placed around a recordset on the top of the page. I'm not sure how that happened. Usually it would be in the HTML and used to display multiple rows. It doesn't make any sense where it is now.

Maybe we can set up a phone call for tomorrow and do screen sharing to figure out what you are trying to do and get it resolved more efficiently. Please post a US phone number or Skype contact information and we can set that up.