Am new CF to but I would try to switch that CFOUTPUT to a CFLOOP. Maybe the
output is doing it twice since the variable it in the cfoutput twice. Here
is copy of some code I did.
Good Luck
<cfselect name="LNI_STO" size="6" multiple>
<option value="ALL" selected>All Sub SER's</option>
<option value="'Unassigned'">Unassigned</options>
<cfloop query="LIST_STO" >
<OPTION
value="'<cfoutput>#list_STO.C_STO#</cfoutput>'"><cfoutput>#LIST_STO.C_STO#</
cfoutput></option>
</cfloop>
</cfselect>
----- Original Message -----
From: "Darren Labrum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 2:24 PM
Subject: Re: CF_Newbie
> 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.
------------------------------------------------------------------------------
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.
