This is a multi-part message in MIME format.
------=_NextPart_000_001F_01C0095D.F35C60E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Yes!
Bill, thanks I didn't know if my little diagram represented what I =
wanted to
show properly but you said it right. That is what I have done with my =
table
relationship.
However, I am having a very difficult time with the Cold Fusion side of
things. For example, I am trying to figure out how to make a form that =
will
allow me to add facilities for a particular park.
I am a newbie so that may sound very elementary. I am trying to make a =
form
that will allow me to assign many facilities that a particular park has.
So the center table (that creates the many-many relationship) looks like
this:
[FacilitiesParkData Table]
FacilitiesID ParkID
23 14
5 14
6 14
and so on.
What is the best way to do this on the Cold Fusion side of things?
Thanks,
Darren
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 18, 2000 7:13 PM
Subject: Re: Funky Relational Tables
> In a message dated 8/18/00 8:26:02 PM Eastern Daylight Time,
> [EMAIL PROTECTED] writes:
>
> << Here is what it looks like:
>
> [ FacilitiesData Table] [FacilitiesParkData Table]
> [ParkData Table]
> FacilitiesID ------------------ FacilitiesID
> Name, etc.
> Facilities
> ParkID =
-------------------------------
> ParkID
>
>
> With this relationship does anyone know how to use Cold Fusion to be =
able
to
> associate many facilities with a particular park. I am having a hard
time
> associating all the facilities a particular Park has to offer. >>
>
> It's not a CF question, it's a data modeling question. It would appear
that
> your many to many relationship is contained or should be contained =
within
the
> FacilitiesParkData Table. This table should have two fields ... one =
for
> primary key of FacilitiesData Table and the second for the primary =
key of
> the ParkData Table. So the center table would have an entry for each =
park
a
> particular facility belonged to. something like:
>
> [FacilitiesParkData]
>
> Facility_id1 ParkA
> Facility_id1 ParkC
> Facility_id1 ParkE
> Facility_id2 ParkA
> Facility_id2 ParkB
>
> Note that this relationship works both ways. That is you can easily =
get
all
> facilities located in a given park or all parks that a facility belong =
to.
>
> Hope this helps.
>
> Bill
> Willow Gold
> http://www.willowgold.com
------=_NextPart_000_001F_01C0095D.F35C60E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Yes!<BR><BR>Bill, thanks I didn't know =
if my little=20
diagram represented what I wanted to<BR>show properly but you said it=20
right. That is what I have done with my=20
table<BR>relationship.<BR><BR>However, I am having a very difficult time =
with=20
the Cold Fusion side of<BR>things. For example, I am trying to =
figure out=20
how to make a form that will<BR>allow me to add facilities for a =
particular=20
park.<BR><BR>I am a newbie so that may sound very elementary. I am =
trying=20
to make a form<BR>that will allow me to assign many facilities that a =
particular=20
park has.<BR><BR>So the center table (that creates the many-many =
relationship)=20
looks like<BR>this:<BR><BR>[FacilitiesParkData=20
Table]<BR><BR>FacilitiesID =20
ParkID<BR>23 &=
nbsp; =20
14<BR>5 =
&=
nbsp;=20
14<BR>6 =
&=
nbsp;=20
14<BR><BR>and so on.<BR><BR>What is the best way to do this on the Cold =
Fusion=20
side of things?<BR><BR>Thanks,<BR><BR>Darren<BR>----- Original Message=20
-----<BR>From: <<A=20
href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A>><BR>To: =
<<A=20
href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A>&g=
t;<BR>Sent:=20
Friday, August 18, 2000 7:13 PM<BR>Subject: Re: Funky Relational=20
Tables<BR><BR><BR>> In a message dated 8/18/00 8:26:02 PM Eastern =
Daylight=20
Time,<BR>> <A =
href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A>=20
writes:<BR>><BR>> << Here is what it looks=20
like:<BR>><BR>> [ FacilitiesData=20
Table] =
[FacilitiesParkData Table]<BR>> [ParkData Table]<BR>> =20
FacilitiesID ------------------ FacilitiesID<BR>> Name,=20
etc.<BR>> =20
Facilities<BR>> &=
nbsp; &n=
bsp; =20
ParkID -------------------------------<BR>> =20
ParkID<BR>><BR>><BR>> With this relationship does anyone =
know how=20
to use Cold Fusion to be able<BR>to<BR>> associate many =
facilities with=20
a particular park. I am having a hard<BR>time<BR>> =
associating=20
all the facilities a particular Park has to offer. =
>><BR>><BR>> It's=20
not a CF question, it's a data modeling question. It would=20
appear<BR>that<BR>> your many to many relationship is contained or =
should be=20
contained within<BR>the<BR>> FacilitiesParkData Table. This table =
should have=20
two fields ... one for<BR>> primary key of FacilitiesData Table =
and the=20
second for the primary key of<BR>> the ParkData Table. So the =
center=20
table would have an entry for each park<BR>a<BR>> particular facility =
belonged to. something like:<BR>><BR>>=20
[FacilitiesParkData]<BR>><BR>> =
Facility_id1 =20
ParkA<BR>> Facility_id1 ParkC<BR>>=20
Facility_id1 ParkE<BR>>=20
Facility_id2 ParkA<BR>>=20
Facility_id2 ParkB<BR>><BR>> Note that =
this=20
relationship works both ways. That is you can easily get<BR>all<BR>>=20
facilities located in a given park or all parks that a facility belong=20
to.<BR>><BR>> Hope this helps.<BR>><BR>> Bill<BR>> Willow =
Gold<BR>> <A=20
href=3D"http://www.willowgold.com">http://www.willowgold.com</A></FONT></=
DIV></BODY></HTML>
------=_NextPart_000_001F_01C0095D.F35C60E0--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
