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.

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.

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?

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.

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?

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.

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.

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.

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