DataAssist Multiple Record Insert

I am trying to use the DataAssist Multiple Record Insert. This works perfectly when my repeat region is from a recordset, but it does work when the repeat region is from a cookie when using ECart. This is code for my repeat region:

<?php while (!$Tech8_Spares_eCart1->EOF()) { ?>
<tr>
<td bgcolor="#E5E8ED"><?php echo $Tech8_Spares_eCart1->DisplayInfo("Code"); ?></td>
<td bgcolor="#E5E8ED"><?php echo $Tech8_Spares_eCart1->DisplayInfo("Quantity"); ?> X <?php echo $Tech8_Spares_eCart1->DisplayInfo("Name"); ?></td>
<td bgcolor="#E5E8ED"><?php echo WA_eCart_DisplayMoney($Tech8_Spares_eCart1, $Tech8_Spares_eCart1->DisplayInfo("Price")); ?></td>
</tr>
<?php
$Tech8_Spares_eCart1->MoveNext();
}
$Tech8_Spares_eCart1->MoveFirst();
?>

DataAssist Multiple Record Insert doesn't reconize this as a repeat region and therefore doesn't work. How can I make this work?

The code for the repeat selection is very specific and differs from these other types of loops. You should try adding in the repeat selection for this area, then inside of the loop you can specify your eCart looping. This should give you a properly formatted repeat selection that the server behaviors will be able to recognize, then in this repeated area you can add in your eCart looping to ensure that you are working with the values in the cart.

I don't know php that well. Can you please demonstrate what you mean with the example code. Thanks

If you are not familiar with php code getting a custom created loop working as you would like may be difficult. The first step for this would be to get a working repeat selection on the page. Have you been able to do this part? If so please post back with your repeat selection code and I can try to give you an example of what I was talking about, or a better one if I can come up with it.

How do I do a repeat selection of cookie fields? You software only allows this on recordsets?

Do not use the DataAssist multiple insert record behavior to store cart information in the database.


included with eCart are 2 server behaviors for database manipulation:
eCart Store Order Summary
eCart Store Order details.


The Store Order Summary behavior is used to create one record in the orders table with information about who placed the order, what the billing address is, the shipping address and such.

the Store Order details behavior is used to store a record in the order details table for each line item in the cart.

you can set this up when using the Checkout Wizard, or you can do it manually by opening the server behaviors panel, click the plus button and going to ecart -> Database manipulation.

In either of those server behaviors, click the help button to go to the help documentation that explains how to use them.