Hey Jason,
Thank you all for you help and comments. Fortunately I found out what I was
doing wrong. I not only needed to join one table but two tables (if that
makes sense). Then the data actually populated the pull down menu
correctly.
SQL can be somewhat tricky when dealing with relational databases.
Thanks,
Darren
----- Original Message -----
From: Jason Aden <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 10:46 PM
Subject: RE: CF_Newbie
> Agreed. You need to have a WHERE clause in there. If there are any fields
in
> those tables that have common data, use a WHERE clause like:
>
> SELECT ci.CityID, ci.City, cu.CuisineID, cu.Cuisine
> FROM CityData ci, CuisineData cu
> WHERE ci.COMMON_FIELD = cu.COMMON_FIELD
>
> Otherwise, there's now way that the data is related to each other. What
are
> all the fields in those two tables? Are there any other tables that
contain
> the ID's from both those tables? If you send that data, I think we can
come
> up with a query that will work.
>
> Jason
> Web Application Developer
> webworld studios, inc.
>
> -----Original Message-----
> From: David Green [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 12, 2000 6:24 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CF_Newbie
>
>
> Like I said am new to this but doesn't there need to be a where or Join on
> the two databases. I am guessing with this your getting records from both
> databases not a single record of the two databases. If there is a key
> between the two data bases I think you need a where statement if you don't
> have keys between the two data bases maybe you need a subquery then in
the
> where statement link by city names. Just guessing
>
> Good Luck
> David
>
>
> SELECT CityData.CityID, CityData.City, CuisineData.CuisineID,
> CuisineData.Cuisine
> FROM CityData, CuisineData
>
>
>
>
> ----- Original Message -----
> From: "Darren Labrum" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, August 12, 2000 3:13 PM
> Subject: Re: CF_Newbie
>
>
> > I tried to change the query around to this:
> >
> >
> > SELECT CityData.CityID, CityData.City, CuisineData.CuisineID,
> > CuisineData.Cuisine
> > FROM CityData, CuisineData
> >
> > and I received two of each city again in my drop down menu.
> >
> > Darren
> > ----- Original Message -----
> > From: Darren Labrum <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, August 12, 2000 3:03 PM
> > Subject: CF_Newbie
> >
> >
> > > This is a multi-part message in MIME format.
> > >
> > > ------=_NextPart_000_0005_01C0046E.83F72620
> > > Content-Type: text/plain;
> > > charset="iso-8859-1"
> > > Content-Transfer-Encoding: quoted-printable
> > >
> > > Hello there,
> > >
> > > I have a question that I think will be answered really fast from all
of
> =
> > > you advanced developers. I am having problems populating a pull down
=
> > > menu. For some reason it will repeat records in the pull down menu.
=
> > > For example, here is a sample of a simple little code I did:
> > >
> > > <select name=3D"Cuisine">
> > > <cfoutput query=3D"guide">
> > > <option value=3D"#CuisineID#">#Cuisine#
> > > </cfoutput> =20
> > > </select>
> > >
> > > Now correct me if I am wrong but is that context look correct?
> > >
> > > The way this will get displayed is like this:
> > >
> > > (the pull down menu will look like this)
> > >
> > > Idaho Falls
> > > Idaho Falls
> > > Boise
> > > Boise
> > > Twin Falls
> > > Twin Falls
> > >
> > > They repeat and I don't understand why is does that? I only have
three
> =
> > > towns in the database (Idaho Falls, Boise, and Twin Falls)
> > >
> > > Yes, I do have the query at the top of the page correct also. =20
> > >
> > > Any thoughts from the Cold Fusion Guru's of the group?
> > >
> > > Thanks,
> > >
> > > Darren
> > >
> > > ------=_NextPart_000_0005_01C0046E.83F72620
> > > 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>Hello there,</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>I have a question that I think will
be
> =
> > > answered=20
> > > really fast from all of you advanced developers. I am having =
> > > problems=20
> > > populating a pull down menu. For some reason it will repeat =
> > > records in the=20
> > > pull down menu. For example, here is a sample of a simple =
> > > little code=20
> > > I did:</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2> <select=20
> > > name=3D"Cuisine"><BR> <cfoutput =
> > > query=3D"guide"><BR> <option=20
> > >
> value=3D"#CuisineID#">#Cuisine#<BR> </cfoutput> =
> > > <BR> </select></FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>Now correct me if I am wrong but is =
> > > that context=20
> > > look correct?</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>The way this will get displayed is
like
> =
> > >
> > > this:</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>(the pull down menu will look like=20
> > > this)</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>Idaho Falls</FONT></DIV>
> > > <DIV><FONT face=3DArial size=3D2>Idaho Falls</FONT></DIV>
> > > <DIV><FONT face=3DArial size=3D2>Boise</FONT></DIV>
> > > <DIV><FONT face=3DArial size=3D2>Boise</FONT></DIV>
> > > <DIV><FONT face=3DArial size=3D2>Twin Falls</FONT></DIV>
> > > <DIV><FONT face=3DArial size=3D2>Twin Falls</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>They repeat and I don't understand
why
> =
> > > is does=20
> > > that? I only have three towns in the database (Idaho Falls,
Boise,
> =
> > > and=20
> > > Twin Falls)</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>Yes, I do have the query at the top
of
> =
> > > the page=20
> > > correct also. </FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>Any thoughts from the Cold Fusion =
> > > Guru's of the=20
> > > group?</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>Darren</FONT></DIV></BODY></HTML>
> > >
> > > ------=_NextPart_000_0005_01C0046E.83F72620--
> > >
> >
>
> --------------------------------------------------------------------------
> > ----
> > > 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.
> > >
> >
>
> --------------------------------------------------------------------------
> ----
> > 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.
>
> --------------------------------------------------------------------------
--
> --
> 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.
>
> --------------------------------------------------------------------------
----
> 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.
>
------------------------------------------------------------------------------
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.
