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

Storing Records from the "Bill To"

Thread began 2/10/2010 9:20 am by jenbar3378469 | Last modified 2/10/2010 5:30 pm by Eric Mittman | 560 views | 2 replies |

jenbar3378469

Storing Records from the "Bill To"

Hi,

I reran your checkout wizard and when I did that it created a page with "Billing" AND "Shipping" sections, which I have working nicely now, however, I am required to store the Billing Details into a new database. The Shipping details are being stored in my "Orders" database. I have created a new MySQL database called "billing details" and have the following columns: BillingOrderID (This is to be the order id number from the "Orders" database), BillingVisitorID (which will be their email address),BillingCompany, BillingAddress1, BillingAddress2, BillingCity, BillingZip, BillingCountry. How can I store this in this new database.

I know own all the WA extensions through my employer, so should I use DataAssist? I have to tell you, I tried already with no luck. I tried the single insertion (going field by field and inserting one at a time) and I tried the repeat region, but no luck. Could it be that I have the session set wrong? Should the session be named the same throughout all of my checkout pages?

Please note, I am storing this from the "Billing" section on the "checkout.php" page. I have attached my "checkout.php" page for your review. I have attempted to use DataAssist to store the email address from the "Billing Information" section into the BillingVisitorID field of my "billing details" database (please see around line 92). I think it may be something with my "session variable". I am not quite grasping it. Do I have it named wrong? What would be the steps taken when wanting to store only certain fields from the "Billing Information" section of the form into a database using DataAssist?

Do we need to open a new ticket?

Thanks!!!!!!!

Attached Files
Checkout.zip
Sign in to reply to this post

jenbar3378469

I am attaching my second attempt. Please read my first message, review the code for both attachments (they were both done totally differently) and PLEASE let me know what to do!

Thanks!!

Attached Files
CheckoutTry2.zip
Sign in to reply to this post

Eric Mittman

Looking at the code you have on these checkout pages it seems that either approach should work, but you will need to have this code on your confirm page, not the checkout. This is because the form on the checkout page posts to the confirm page, so the triggers you are using are valid when placed on the confirm page.

You should open your confirm page and add in the DataAssist Insert server behavior here. You may want to update the trigger though to work the button on this page.

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