RE: defining price column with mySQL

["Russ" <russ@khouse.org>]

I'm using decimal(8,2) and doing ok...  I'm not effectively using a [sql
type=list] yet...

-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Dave 'Duke of
URL' Weiner
Sent: Wednesday, July 14, 1999 2:22 PM
To: minivend-list
Subject: defining price column with mySQL


******    message to minivend-users from "Dave 'Duke of URL' Weiner"
<davew@webmast.com>     ******

What is everybody setting the price column to in their mySQL tables?  I
currently have the column name as price, and I've tried decimal(8,2),
float(8,2) and char(12), but when I use the [sql-price] tag inside a [sql
type=list] [/sql] list, it just returns $0.00.  I know there are values in
the price column, and [sql-code] and [sql-description] work.

TIA,

Dave


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list