Re: [mv] quantity pricing with multiple product databases

[John Turner <johnt@compar.com>]

******    message to minivend-users from John Turner <johnt@compar.com>     ******

We do seem to have a misunderstanding here, so perhaps I can clarify:

1. The prices in prodktm.txt and in the mysql prodktm database are pure
numeric format, eg. 1.23 NOT $1.23
2. The price of prodktm items appears correctly on the results.html and
flypage.html pages, but always shows as zero on the quantity.html page.
3. Within the quantity.html page when the current item is on prodktm
	the values of item-price, item-data prodktm price and loop-price
        on prodktm) are apparently all zero
4. Within the quantity.html page when the current item is on products
        the values of item-price, item-data products price and
loop-price
        are all correct and not zero 

Hans-Joachim Leidinger wrote:
> John Turner schrieb:
> > I do not clearly remember which way around it was but I did try to
> > control the display using an [if] based on this result.  One of
> > [item-price noformat] and [item-price noformat=1] gave $0.00 and the
> > other gave 0, if the item was in prodktm.   If the item was in products
> > then the result would be either $123.00 or 123.   If [item-data prodktm
> > price] was the reference then it was always $0.00 or 0 regardless of the
> > table the item was in, but [item-data products price] gave the right
> > values if the item was in the products file.   This was essentially how
> > I deduced the price was zero inside quantity.html if the item resided in
> > the auxilliary products file.
> 
> Sorry, but it is difficult to understand you (I'm an old german boy). If
> I undertand you right, the
> 
> [item-price or whatsoever with noformat or noformat=1...]
> 
> print out such kind of "$xyz", remove any chars (for example "$") from
> your any database (or tables).
> 
> Perl will get the value "0", if there are any character with any numbers
> in the price field.
> 
> I would stongly suggest to insert _only_ numbers into the price field
> (for example "123.45" or "999.99" and not "99,00" or "123,00").
-
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