[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
problems with [sql list=] and [sql-price]
MV 3.14
MySQL 3.22
Mandrake Linux 6.0, 2.2.9 kernel
Apache 1.3.6
I'm using the following code in a page:
<table border=0 align="center">
[sql type=list base=apparel query="select * from apparel where code like
'NE0001%'"]
<tr>
<td><font face="arial">[order [sql-code]]Order[/order] our fine
[sql-description] for only [sql-price]</font></td>
</tr>
[/sql]
</table>
the table apparel is defined in catalog.cfg like this:
ProductFiles jewelry books software apparel storeinfo
Database apparel apparel.asc dbi:mysql:mmall:localhost:3306
Database apparel COLUMN_DEF price=float, weight=float
Database apparel NUMERIC price, weight
I have also tried
Database apparel COLUMN_DEF price=char(12), weight=float
Here's the problem. The [sql-code] and [sql-description] tags work perfect,
but I get $0.00 for the [sql-price] tag. I know there is data in the field,
because if I use the [sql-param X] tag, I can get the price. I have also
tried [sql_price] with the same results. I'd really like [sql-price] to
work, it would simplify the project I'm working on. Otherwise, I have to
change all the checkout pages and insert all the calculations by hand.
As you can see from this query, the price column is named "price", so the
default setting of PriceField should work. Has anybody ran into this?
mysql> select * from apparel;
+----------+-----------------+-------+--------+------+-------------------+--
----+
| code | description | price | weight | size | color |
info |
+----------+-----------------+-------+--------+------+-------------------+--
----+
TIA,
Dave