close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DataAssist Multiple Record Insert

Thread began 12/16/2009 10:42 am by info307537 | Last modified 12/18/2009 4:11 pm by Jason Byrnes | 1455 views | 5 replies |

info307537

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?

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

info307537

Example code please

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

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

info307537

Repeat Selection on a cookie

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

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