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.
