On 4/1/01, Karl Simanonok penned:
>Thanks for your thoughtful reply. I follow your logic, which makes
>sense, but it doesn't cover all cases. For example, let's say
>you've got light bulbs in your database like 1152's and 1157's (I
>think those are valid numbers). Do you have an entry in the
>Availability table for every single vehicle they're used in?
Sure. I guess you'd have to. Somewhere you're going to have to
specify which light lamp fits which vehicle. Better than entering a
zillion different lamps. It looks like it's definitely going to need
to run on SQL Server since even if you only have 1,000 parts, you're
probably going to end up with 100,000 entries in the Availability
table. Especially if you get into selling stuff like lamps and wiper
blades, etc.
>
>What do you do if you have say, fender skirts in three different
>colors, all costing the same? Do you represent these with three
>different entries in the Products table? If so you need a Color
>field. But colors won't apply to all products so in that case
>you've got a bad DB design.
>You could have a separate Colors table with just one record in the
>Products table for all three colors but then you need some kind of a
>flag in the Products table which tells you to look there, and logic
>requiring at least two queries to get all the information you need.
>How do you see resolving this problem?
I have a color table in the database with Color IDs and Color Names.
The products table has a field which is just a list of color IDs. If
that's not empty then it runs a query of the list items to pick up
the colors from the color table. I guess you could go ahead and enter
every color of every vehicle ever made if you wanted. LOL
http://www.cf-ezcart.com/
Click on Glass Creations and scroll down to the peacock.
>
>I'm not in a major rush but it's coming up soon. I will happily
>share with you any solutions discovered or invented. Thanks for
>your help, Bud.
Okeydoke. I'm pretty much stuck on using my own cart, which may not
be a solution if you're going to be doing a site for Discount Auto
Parts or someone that carries every part for every vehicle ever made.
Hell, even if you could build it in a week, it would take 2 years to
enter all the parts. LOL
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
