Confused big time..about ColdFusion

Hi,

I have a form that updates ingredients. The first table is where the
specific ingredient is stored for a specific recipe. Something like this...

RecipeIngredientID | RecipeID | IngredientID | Quantity | Comments     |

1			   1		 Potato		3	   cut in pieces
2			   1		 Chicken		1	   cut in small pieces

...etc


Now I'm trying to show the IngredientID column to the user, except that
IngredientID has a relationship with another table called Ingredients (which
stores the actual names). As far as access is concerned the IngredientID in
the table above is a number (The Primary Key for the Ingredients Table), And
everytime I try to display the name of the Ingredient I get the ID number
instead. How do I show the name, instead of the number, plus keep a running
list going for every ingredient they add.

If I'm not explaining right let me know and I'll try to clear it up.

Any help would be appreciated,

Phil

-----Original Message-----
From: Brook Davies [mailto:brook(at)maracasmedia.com]
Sent: Friday, August 23, 2002 4:12 PM
To: CF-Talk
Subject: RE: Restricted Access SQL Server Login


Thanks for the tip. Care to elaborate?

At 03:45 PM 23/08/02 -0400, you wrote:
>Yes, in your SQL Server Enterprise Manager.
>
>Matthew Small
>IT Supervisor
>Showstopper National Dance Competitions
>3660 Old Kings Hwy
>Murrells Inlet, SC 29576
>843-357-1847
>http://www.showstopperonline.com
>
>
>-----Original Message-----
>From: Brook Davies [mailto:brook(at)maracasmedia.com]
>Sent: Friday, August 23, 2002 3:58 PM
>To: CF-Talk
>Subject: OT: Restricted Access SQL Server Login
>
>Is there a way to create a sql server login that does not have
>permissions
>to DELETE|DROP|ALTER and have these permissions applied to all tables in
>a
>DB without individually specifying the permissions per table?
>
>Brook
>
>
>
>

______________________________________________________________________
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/cf-talk(at)houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA