Repeat regions

I looked through your forum and didn't see a direct corollary to this issue. I've got a simple table set up that displays members of our organization who are from countries other than the US. First column is Name, second column is Country. Final row displays total foreign members. In the Name column I have bound it to lastname, firstname, and country goes in the second column. In the query I have it set up to be sorted by country = ASC. I selected the entire first row and wrapped your Repeat Region around it. What I expected was a table with multiple rows containing names and country of origin, sorted by country (this is what I accomplished using the older DW MySQL Repeat Region). Instead, this is being displayed in the browser all run into the first row so that it goes well beyond the borders set for the table.

I rebuilt everything from scratch: recordsets, bindings, and server behaviors. I also followed your tutorial. Can you help me with this? File is attached.

you have the repeat around the cells for the row:

<tr class="borderRow">
<?php
while(!$foreignMembers_i->atEnd()) {
?>
<td><?php echo($foreignMembers_i->getColumnVal("lastname")); ?>, <?php echo($foreignMembers_i->getColumnVal("firstname")); ?></td>
<td align="center"><?php echo($foreignMembers_i->getColumnVal("country")); ?></td>
<?php
$foreignMembers_i->moveNext();
}
?>
</tr>


it should be around the row
<?php
while(!$foreignMembers_i->atEnd()) {
?>
<tr class="borderRow">
<td><?php echo($foreignMembers_i->getColumnVal("lastname")); ?>, <?php echo($foreignMembers_i->getColumnVal("firstname")); ?></td>
<td align="center"><?php echo($foreignMembers_i->getColumnVal("country")); ?></td>
</tr>
<?php
$foreignMembers_i->moveNext();
}
?>



when applying the repeat, make sure you select the TR tag in the tag selector.

Excellent, that worked. Thanks very much for your help and patience!

Gail

you're welcome.