[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [item-price] with a sql database
On Mon, 21 Dec 1998, Jonathon Spaeth wrote:
> I have a Postgres database set up. I can run queries and get data correctly from minivend, however, on my basket page, when I use [item-list] to loop through the items, [item-price] comes up $0.00 on everything. My products database is set up with a p
rice field. I even put the PriceField in the catalog.cfg. I tried using field types of both money and text with the same result: $0.00 for the price.
>
> Has anybody else successfully got this working? If you have any ideas, please feel free to share them with me.
You may need to tell MV the names of your columns with a Database NAME
directive. e.g.
Database products NAME code model finish msrp price oversize
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82