MiniVend Akopia Services

[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

Search for: Match: Format: Sort by: