Depending on the depth of you database, the best thing to do would to be
create a master RECIPE table, and a master INGREDIENT table. The, you could
create an linkage table that would like n number of ingredients to a recipe.
EXAMPLE:
RECIPE
==================================================
RC_ID RC_NAME RC_DESCRIPTION
--------------------------------------------------
10 Chocolate Cookies Yummy!
20 Chocolate Brownies More Yummy!
INGREDIENT
==================================================
IN_ID IG_NAME IN_DESCRIPTION
--------------------------------------------------
1 Flour White Stuff
2 Sugar Sweet Stuff
3 Egg Yolks & Stuff
4 Salt NaCl2
5 Chocolate Good Stuff
6 Chocolate Chips Little Stuff
RECIPE_INGREDIENT
=============================
RI_ID RC_ID IN_ID
-----------------------------
1 10 1
2 10 2
3 10 3
4 10 4
6 10 6
7 20 1
8 20 2
9 20 3
10 20 4
11 20 5
The table, RECIPE_INGREDIENT, would contain an identity for the relationship
(RI_ID), a reference to the recipe (RC_ID) and a reference to the related
ingredient (IN_ID).
So, to find out what ingredients are used in Chocolate Brownies, you could:
SELECT RI.IN_ID, IN.IN_NAME, IN.IN_DESCRIPTION
FROM RECIPE_INGREDIENT RI JOIN
INGREDIENT IN ON RI.IN_ID = IN.IN_ID
WHERE RI.RC_ID = 20
You can go even farther and attach the recipe details to this query. But I
hope this leads you in the right direction!
--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]
-----Original Message-----
From: Deborah Curley [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 1:31 PM
To: CF-Talk
Subject: CF/Database Help
Hi,
I have a friend whose a chef and has asked me build him a database of
recipes and a web app he can use to search, enter new recipes, etc. What I'm
trying to figure out is the best way to store the ingredients since a recipe
can have anywhere from 5 to 20 ingredients? Any ideas on the best way to
handle that?
TIA,
Deb
_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
