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

Trouble with DetailOrderID recording

Thread began 5/27/2010 5:49 pm by paul298707 | Last modified 5/28/2010 4:31 pm by paul298707 | 1041 views | 7 replies |

paul298707

Trouble with DetailOrderID recording

I'm trying to link my customer_order_history page to the customer_order_details pages. The link works, but no info show up in the details page.

In my sql database, I notice that no DetailOrderID info is being submitted/entered.

What page or where and how do I make sure this info is inserted. Thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

The order summary and order details are stored to the database on the Confirm page.


On the confirm page, open the server behaviors list.

Double click on the eCart Store order Summary server behavior.

make sure that the Primary key column is selected for Order ID and make note of the name that is set in the Store As section, then click cancel.

Click on the Bindings tab and expand the session collection. Make sure there is a session variable listed here with the name you noted from the Store as section of the Store Order Summary behavior.

Back on the Server Behaviors tab, double click the eCart store order Details server behavior.

For Order ID select the detailOrderID column, then in the columns list, maker sure the detailOrderID column is bound to the session variable that is set by the Store Cart summary behavior.

Sign in to reply to this post

paul298707

Not seeing anything saying Primary Key

This post has been deleted.

paul298707

Getting close, need to clarify a few more things

Hi Jason,

Tried your steps above -- still not working, but I think we're close.

To clarify:

There is nothing referencing "Primary Key" in the ecart store summary behavior. I have selected the ORDERS table, and underneath that there's a spot that says Order ID: and I selected OrderID. Is this the same as primary key?

The store as was: ArticleCart_OrderID

This was NOT listed as a session variable -- so I added a session variable named ArticleCart_OrderID. Was this correct?

And as for this part: "For Order ID select the detailOrderID column, then in the columns list, maker sure the detailOrderID column is bound to the session variable that is set by the Store Cart summary behavior."

Do you mean to bind the detailOrderID column to the ArticleCar_OrderID session variable I just created?

I just ran a "test" purchase through PayPal and everything works up until the customer_order_details page -- and still no DetailsOrderID being recorded. Please advise. Thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

Please send a copy of your confirm page so I can examine the code.

You will want to mask the paypal account details in the code when you attach it here.

Sign in to reply to this post

paul298707

orderdetails_DetailsID or ArticleCartOrderID

Looking at my session variable on the confirm.php page, I noticed these two session variable:

orderdetails_DetailsID (this one was already there)

ArticleCartOrderID (I added this one after reviewing your steps above)

I'm wondering if I should have just changed my server behavior "save as" to orderdetails_DetailsID instead of adding the new one?

Help.

Sign in to reply to this post

paul298707

My confirm page code is attached

My confirm page code is attached.

I'm hoping to get though this problem and the download_center page today so any advice is appreciated. And yes, I've been through the guides several times but I always seem to have a little problem or two.

My fault I'm sure -- so I appreciate your help.

Paul

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

Jason ByrnesWebAssist

The session variable to use in the Order details is:
ArticleCart_OrderID

you have bound both the detailsID and DetailOrderID columns. The detailID column should not be bound to anything, this column will automatically be assigned a value by the database.

Sign in to reply to this post

paul298707

That was it, thanks Jason

And for anybody reading this, remember you may have confirm.php page AND a pp_confirm.php (PayPal).

:)

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