[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] pricing nightmare
****** message to minivend-users from "Mr. Christopher F. Miller" <cfm@maine.com> ******
Make a price field. Set it to zero. Minivend will
be happier that way.
Then play with the examples in CommonAdjust section
and you should get the hang of it.
SQL has nothing to do with it. See how much easier it is. ;^>
cfm
On Tue, Feb 01, 2000 at 02:52:45PM -0600, Marty Vance wrote:
> ****** message to minivend-users from Marty Vance <mvance@lwm.com> ******
>
> My catalog is completely SQL based. My products (art) table does not
> contain a price field, as the price needs to be driven by the size
> selected by the user in a form. The art table contains fields
> artID|galleryID|ratioID|orientationID|title|artist
>
> The art is to be sold with a frame, as a set. The size of the frame and
> what group it belongs to are what need to be used to set the price. The
> frame table contains fields
> frameID|description|groupID|history
>
> The size table contains fields
> sizeID|width|height|ratioID
>
> I have a price table that contains fields
> sizeID|groupID|artprice|frameprice
>
> The catalog contains 450~ pieces of art, and 24 frames.
>
> The docs and mail list entries about CommonAdjust etc (basically the
> entire pricing section) make no sense to me. Has anyone out there done
> anything this complex using SQL?
>
> Marty Vance
> LiveWire
> mvance@lwm.com
> www.lwm.com
>
> -
> 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
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.
-
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
