Hi there,
Frank, thanks for the response. I put in SELECT DISTINCT in my query but I
still get repeating records when I populate the drop down menu.
I just can't determine what is going on here.
Thanks,
Darren
----- Original Message -----
From: Frank Priest <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 3:12 PM
Subject: Re: CF_Newbie
> The problem is in your query Darren,
> You need to
>
> SELECT DISTINCT CuisineID, Cuisine
>
> Frank
>
>
>
> At 03:03 PM 8/12/2000 -0600, you wrote:
> >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">
> >Hello there,
> >
> >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:
> >
> > <select=20 name=3D"Cuisine">
> > <cfoutput = query=3D"guide">
> > <option=20 value=3D"#CuisineID#">#Cuisine#
> > </cfoutput> =
> > </select>
> >
> >Now correct me if I am wrong but is = that context=20 look correct?
> >
> >The way this will get displayed is like = this:
> >
> >(the pull down menu will look like=20 this)
> >
> >Idaho Falls
> >Idaho Falls
> >Boise
> >Boise
> >Twin Falls
> >Twin Falls
> >
> >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)
> >
> >Yes, I do have the query at the top of = the page=20 correct also.
> >
> >Any thoughts from the Cold Fusion = Guru's of the=20 group?
> >
> >Thanks,
> >
> >Darren
> >
> >------=_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.
