Re: [ic] Quantity pricing does not take effect

[Marcel Montes <marcel@multimake.com>]

it happens to me too....
But I wasn't able to delete
the price from the products table (using MySQL)
due to the fact that the
price column cannot be empty and if I set it to 0....
pricing still doesn't take
effect.

sql error when price is empty (shows on the html).
--------------snip---------------
Sorry, there was an error in processing this form action. Please report the error or try again later. (You have an error in your SQL syntax near 'where sku
= 'br10001' ' at line 1 )
--------------snip---------------
--------------snip---------------
mysql> select sku, description, price from products where sku='br10001';
+---------+------------------------+-------+
| sku     | description            | price |
+---------+------------------------+-------+
| br10001 | Opera v4.0b2 for Linux |  0.00 |
+---------+------------------------+-------+
1 row in set (0.00 sec)
--------------snip---------------

Chris Wenham wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

 I have one product in a catalog with quantity pricing, however the
 pricing does not take affect when the item is ordered.

 The strange thing is that when I -delete- the price from the products
 table (leaving only the data in the pricing table), the shopping cart
 display reflects the quantity price for all quantities greater than
 1. But for a quantity of 1, the price is naturally zero.

 How do I fix this?

Regards,

Chris Wenham
NetMonger Communications

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (FreeBSD)
Comment: Processed by Mailcrypt 3.5.5 and Gnu Privacy Guard <http://www.gnupg.org/>

iEYEARECAAYFAjoixk0ACgkQw4VAKENtJO+5SACfbeNYlfWxCvqDR2o7uBl9FCdz
cigAn1YBCvbCHfbUCmFoR1Dx/RkgNyDI
=2ybO
-----END PGP SIGNATURE-----

_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users

-- 
 Marcel Montes [marcel(at)multimake(dot)com] - Programmer  
 "If our brain were so simple that we could understand it, 
 we would be so stupid that we couldn't do so"
-------------------------- EOF ----------------------------