Re: Odd order number

[Kyle Hayes <khayes@quicknet.net>]

******    message to minivend-users from Kyle Hayes <khayes@quicknet.net>     ******



On Fri, 4 Jun 1999, Ryan Hertz wrote:

> At 11:40 AM 6/4/99 , Kyle Hayes wrote:
> >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?

I make it in the checkout profile in checkout.html.  It is a hack :-)
But, it seemed to do the job.  Within a [sql] block, it is almost as if
certain state is not visible.  I have had no luck at all with scratch
variables being used within SQL:

[sql type=set base=orders interpolate=1]
	INSERT INTO orders (order_code, payment_auth)
	VALUES ('[value mv_order_number]','[scratch payment_auth]')
[/sql]

This seems to set the second argument to "" if the scratch variable is
defined within the checkout profile block.  If I don't do the 
	&set=mv_order_number [value mv_order_number]
call before the SQL, then [value mv_order_number] seems to come back
empty.

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

This is what I was wondering.  This is going to make my life difficult.
Due to other constraints, I need to store the pending order _before_ the
credit card authorization.  If I don't, there is a chance (small, but not
zero) that I will charge the credit card without placing and order for
fulfillment.  That is not acceptable :-(

Our customers can order through our web site in two ways.  The first is
via credit card (which now looks like it might take a two-level ordering
scheme) and the second is via FAX.  They do the order online, but get a
page at the end that they must fax along with a copy of their credit card
to us.

Is there a way to have one submit button take customers to the credit card
page and another straight to the end report page?  In looking at the
recently posted example of a two-level check out system, it looks like it
could be done...

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

Hmm, unfortunately that makes it a tad difficult to do what I wanted.  I
think there is a work around with a two level checkout page, but that
isn't exactly what I wanted.  

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