MiniVend Akopia Services

[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





Search for: Match: Format: Sort by: