[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Multiple ID's and pull-downs
We do something like this. Build a flypage that selects the title, based on the
id number, then uses that title to select all products with the same title. I.E.
Select products.* from products,products as b where products.title = b.title and b.code = '[item-code]';
Then use the result of this query to build a minivend order select list.
On Thu, Jun 24, 1999 at 04:04:48PM -0400, Patrick Schoonveld wrote:
> ****** message to minivend-users from Patrick Schoonveld <pschoonveld@venux.net> ******
>
> I have a client who requires there to be multiple product id's for
> different attributes of the products. They would prefer to have
> pull-downs to do this. We currently implemented their system using
> GoldPaint due to a salesman's choice (not good. hasn't been developed at
> all in the past 2.5 years). Basically it would work like this:
>
> id title color size
> 1000 shirt1 red XL
> 1001 shirt1 red L
> 1002 shirt1 red M
> 1003 shirt1 red S
> 1004 shirt1 blue XL
> 1005 shirt1 blue L
> 1006 shirt1 blue M
> 1007 shirt1 blue S
>
> Then a page with 2 pulldowns that you choose the color and the size.
> Then it adds that id number to the user's cart.
>
> I am sort of at a loss for this. Another guy wasted a heck of a lot of
> time (2 MONTHS!!!!!) with GoldPaint, and we don't really want to waste
> any more time with it. Being a freeware advocate, I suggested the
> immensely powerful MiniVend, and am researching it. But, I am new to it.
> I know perl fairly well, so I have a few ideas about changing the way
> adding an item to the shopping cart actually happens (make it id-less,
> and just search for the id at that time based on the attributes), but
> would prefer to see if MiniVend has a way to handle that. Any tips,
> trick, filthy comments or hate mail are appreciated, as I am new to
> MiniVend.
>
> Thanks,
> Patrick Schoonveld
> Venux Technology Group
>
> "I am, after all a programmer by background, and optimism is an
> occupational hazard."
> - Fred Brooks, _The Mythical Man Month_
> -
> 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
--
Anthony Ball ant@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
tel:1.207.657.5078 fax:1.207.657.5048 http://www.maine.com/
