multiple insert issues
I am trying to create a multiple insert using the new server behaviors. I have created an recordset and added the variables to the page (within a form) I have tried using the MySQLi > Repeat Selection Improved to create a repeat region.....
<?php
$wa_repeatfor = -1; // Repeat Selection 2
if (!isset($wa_repeatcount)) $wa_repeatcount = 0;
while (!$confs->atEnd() && $wa_repeatfor != 0) {
$wa_repeatfor--;
$wa_repeatcount++;
if (!$confs->atEnd()) {
?>
<input name="service" type="hidden" id="service" value="<?php echo($confs->getColumnVal("Service")); ?>">
<input name="Uploadconf" type="hidden" id="Uploadconf" value="<?php echo($confs->getColumnVal("UploadConf")); ?>">
<?php echo($confs->getColumnVal("Service")); ?>
,
<?php
if ($wa_repeatfor != 0) $confs->moveNext(); // Repeat Alternate 2
} else {
?>
<?php
} // End Repeat Alternate 2
?>
<?php
}
if (!isset($wa_startindex)) $confs->moveFirst(); // End Repeat Selection 2
?>
And I have tried MySQLi > MySQLi Repeat Region.....
<?php
$wa_startindex = 0;
while(!$confs->atEnd()) {
$wa_startindex = $confs->Index;
?>
<input name="service" type="hidden" id="service" value="<?php echo($confs->getColumnVal("Service")); ?>">
<input name="Uploadconf" type="hidden" id="Uploadconf" value="<?php echo($confs->getColumnVal("UploadConf")); ?>">
<?php echo($confs->getColumnVal("Service")); ?>
<?php
$confs->moveNext();
}
$confs->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>
However when I come to adding the Muliple Insert behaviour I get the same pop up saying 'Your page must contain form elements in a repeated region to use this interface'. I have saved each page after adding the repeat region but I just can't get it to work.