Cool, thank you for the advice. I am still learning about databases and
making relations between the tables. And this helps out a lot:) Thank you
again.
Donald Pavlik
-----Original Message-----
From: Jim Nitterauer [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 6:22 PM
To: Fusebox
Subject: RE: Comma Delimited lists
Don,
Setting up a database the way you are doing it violates standard
normalization rules and is bad practice in database development. It will
come back to bite you in the butt later - trust me. Your best bet is to
create a child table linked by the id field of the parent. Ex:
Master tables:
Assembly
--------
id
name
etc
Parts
-----
id
name
etc
Child Table:
Assembly_Components
-------------------
id
assembly_id
part_id
This way you can be sure to limit data duplication and allow referential
integrity to be enforced.
Jim Nitterauer
http://www.creativedata.net
-----Original Message-----
From: Donald R. Pavlik [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 25, 2000 10:01 PM
To: Fusebox
Subject: Comma Delimited lists
I have a few fields in my databases that use comma delimited lists in them,
my biggest problem is that I have not found a way where I could go through
it and have certain actions be done for each item in the list. For example,
I have a field that has all the partIds that make one part assembly in a
field, (2,4,6,29) and then I would like a link made off of this information.
I want a query done for each number, and then a link to be make out of the
drawn information put up on a web page. I know I should be able to do this
with <cfloop></cfloop> and have a <cfquery></cfquery> inside the loop for
each number, but I just don't seem to understand how to do it. I have read
my coldfusion books on it, and I just get lost on how to do it. Can any of
you help shed some light on this for me?
Thank you,
Donald Pavlik
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
