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.
