Re: Odd order number

[Ryan Hertz <rhertz@gyb.baits.com>]

******    message to minivend-users from Ryan Hertz <rhertz@gyb.baits.com>     ******

At 11:40 AM 6/4/99 , Kyle Hayes wrote:
>******    message to minivend-users from Kyle Hayes <khayes@quicknet.net>
   ******
>I am using MiniVend 3.12 on RedHat Linux 6.0 with Apache (errrr... some 
>fairly recent version...) and
>MySQL 3.22.x (again, quite recent version).
>
<Snip>
>I am attempting to store order information in the check out profile.  
>While it stores correctly, I have seen two oddities that I don't 
>understand.
>
>1) the variable mv_order_number is blank.  If I place the line:
>    &set=mv_order_num [value mv_order_num]
>in the code, then I get a valid number (000016 for instance).

	Where do you make this set?   I couldn't find code like this in any of my
checkout/report/receipt pages...  Can you determine, by looking at
/your/loc/to/mvend/sample/etc/order.number if that causes the number to
increment?

>
>If I do this, then my SQL code runs fine and inserts the appropriate 
>rows into my order database.
>
>Great.  Except for problem two:
>
>2) The order number that prints on the receipt report is not the same 
>as the number that is inserted into the database.  It is exactly one 
>more.  For instance, if the order is placed in the database with order 
>number 000016, then the receipt says 000017.

	I think the problem is that the order number is magic.  If you touch it
before the order is complete, it increments - you should put your db insert
on the receipt or report page...  but, if the db becomes +1 of the receipt,
it's not my fault.  ;-)

>
>???!??
>
>Is the order number incremented after the &final=yes?  I am doing the 
>insertion into the order database _before_ the &final line.  I want to 
>have the following steps occur:
>
>- check basic fields
>- insert order attempt into order database
>- check credit card info
>- update previously inserted order with credit card authorization info
>- show receipt.
>
>Any ideas?  The odd blank value is disturbing.  The fact that the 
>receipt has a different order number than the value used in the check 
>out profile in checkout.html is weird too.

	It must be blank because you're pulling it too soon... my guess.

>
>Best,
>Kyle
>-
>To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list
> 

Ryan Hertz                                              tel  520-645-3812
Webmaster                                               tel  800-645-BAIT
Advertising Director                                    fax  520-645-2588
Gary Yamamoto Custom Baits, Inc.            http://www.yamamoto.baits.com
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list