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

what goes in the detail order id column of details behaviour?

Thread began 2/10/2010 5:16 pm by ant.knott394719 | Last modified 2/16/2010 4:55 pm by Eric Mittman | 1578 views | 8 replies |

ant.knott394719

what goes in the detail order id column of details behaviour?

Im trying to set up remote access with paypal and php.

I've restricted access to visitors and my checkout pages are all created but i'm a bit confused about binding data in the summary and order details behaviour so i'm following the steps in the e-commerce solution recipe. I've created a visitor recordset and session variable called MM_UserGroup. In the summary behaviour i've set the column OrderUserID to dynamic data Session > MM_UserGroup as shown in the attached image and i now need to know what goes in the detailOrderID column in the details behaviour. At the moment it is
<?php echo session_id(); ?> but i'm not sure if this is correct, should it be MM_UserGroup ie. the same as the summary behaviour. I will need to populate the other columns such as billshippingaddress but i'll ask about how i do this later. thanks in advance for your help with this.

Sign in to reply to this post

Eric Mittman

When you setup the store order summary you should be using the session variable as the reference id value. This server behavior should store the id for the inserted order into a session variable. You should use this session variable as the detailOrderID in the store order details server behavior.

If you have any more questions about this or need more explanation of any part let us know.

Sign in to reply to this post

ant.knott394719

Need a bit more info?

Just to clarify as i'm having a bit of difficulty understanding this area. i click on the lightning in the store summary behaviour of the confirm page. For the OrderRefID I select Session ID (not the MM_UseGroup session variable described in the tutorial) and for the OrderVisitorID i click the lightning and select the next one down (ID) .

In the store summary behaviour for DetailOrderID i click on the lightning and select under ecart the Session ID and for the ItemID i select ID. Let me know if this is correct or if i am meant to leave the DetailOrderID blank.

My only problem i have with this is that i was very pleased when i found the tip for using the date and random no for a reference number, <?php echo ((time() + rand())); ?>
this creates a number that isn't too short and isn't too long and will look good on the auto confirmation email that i am hoping to set up with universal email, the really long number that i've seen get generated looks terrible but if this is the best way to do it then this is how i'll do it. As long as everything works well, thats the main thing. I'll try the above whilst i'm waiting for a reply to see what happens.

pls note i've kept the top item on both behaviours (OrderID and DetailID) blank, i hope that is correct?

Sign in to reply to this post

ant.knott394719

Didn't work so i'm now baffled

I obviously have it all wrong as its not redirecting to paypal anymore, just a white screen with the message 'Unknown column '8ae993c37516d26c8ad60dc535f7cb46' in 'where clause'
this must be the long reference number i don't like.

When i went into the store details behaviour for the first time there was a value in the top column DetailsID, it was quite long and had the word session in it but i deleted it as i was attempting to copy the values in the solution recipe, perhaps i was meant to keep this, is this is why its not working? do i need to put this code back in or is it not needed.

Ater getting a blank screen i tried removing the value in the DetailOrderID of the details behaviour altogether but it wouldn't let me do this. Could you point out where i'm going wrong. Thanks v. much.

Sign in to reply to this post

ant.knott394719

summary and details

Just to make it clear, at the moment the behaviours look like this.

summary behaviour

OrderID is empty
OrderRefID has <?php echo session_id(); ?>
OrderVisitorID has <?php echo $eCart1->DisplayInfo("ID"); ?>

details behaviour

DetailsID is empty
DetailOrderID has <?php echo session_id(); ?>
DetailItemID has <?php echo $eCart1->DisplayInfo("ID"); ?>

These were obviously selected by clicking the lightning bolt and going to ecart.
Should i be clicking the lightning and then chosing something from session like this
<?php echo $_SESSION['VisitorID']; ?> for example?

Sign in to reply to this post

Eric Mittman

So long as the values match and you can relate the data that is all that matters. This looks like it would to that, you would just need to remember that the order reference id maps to the detail order id.

If you can post back with a copy of the page with this code I could check it to see if it looks ok.

Sign in to reply to this post

anthony399409

It looks like the wizard is setting the DetailOrderID as '<?php echo session_id(); ?>' instead of the '<?php echo ((isset($_SESSION["YourCart..'

Can someone post the rest of the syntax for the latter? The GSG shows this syntax, but not the entire line.

Sign in to reply to this post

ant.knott394719

Its all sorted.

I've changed this now but thanks anyway, it wasn't picking up the session when i went into the server behaviour but i reran the ecart wizard from scratch and in the bindings part of the wizard i was able to pick up the session, it now works perfectly.

Sign in to reply to this post

Eric Mittman

The eCart order id and this session id value should be the same.

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