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.
