[mv] Problem using common adjust - Need help please

[mike@iqfactory.com]

******    message to minivend-users from mike@iqfactory.com     ******

Hello,
I'm trying to use the CommonAdjust directive but i'm getting stumped.

Here's the situation:
I would like to add an attribute to some of the products in our products
database -- framed and unframed.

As per rule 3 (assuming PriceField is set to price) any items in our
database that will use the CommonAdjust string have a price of 0

--------
Rule 3.
"If the value of the CommonAdjust directive is set to a CommonAdjust string,
and the price field is empty or specifically 0, then it will be used to set
the price of the items."
--------

this is also from the docs
-------
==attribute:table*:column*:key*
   Does an attribute-based adjustment.  The attribute is looked up in the
database 'table', with the optional 'column' defaulting to the same name as
the value of the 'attribute'.  If the column is not left blank, they key is
set to the value of the 'attribute' if blank.
-------

My CommonAdjust string is as follows:
CommonAdjust  ;products:price, ==type:pricing
where the fallback price is products:price and my attribute is called type.

i have a pricing database defined that looks like this.

code	unframedprice	framedprice
bc02-27	450.00	570.00
bc03-01	450.00	570.00
bc03-16	450.00	570.00
...

The html snippet from my results page looks like this:

<FORM ACTION="[process-target]" METHOD=POST>
    <INPUT TYPE="hidden" NAME="mv_order_item" VALUE="[item-code]">
    <INPUT TYPE="hidden" NAME="mv_todo" value="refresh">
    <INPUT type="hidden" NAME="mv_order_quantity" VALUE="1">
	[item-code]-[item-description]<br>
<!-- as per the docs -->
    <SELECT NAME="[modifier-name type]">
    <OPTION  [selected [modifier-name type] unframedprice]> Unframed price:
[item-price]
    <OPTION  [selected [modifier-name type] framedprice]> Framed price:
[item-price]
    </SELECT>
<!-- end -->
    <INPUT TYPE="submit" VALUE="submit">
</FORM>

What i get when i view the page is item-price is $0.00 for all items that
have an item-modifier.  This may be correct on this page since [item-field
price] should be 0 for these items.  But the items also show up as $0.00 in
my basket.

Please Help!!!  Any suggestions?

Regards,
Mike K.




-
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