Are you using Access97?
If so, it implements a non-standard "Distinct"
It finds a distinct ROW when you specify more
than one column.
So to get distinct CITIES you need to filter your query,
or select City ONLY to populate your drop-down a la:
SELECT Distinct City
best, paul
(If I remember a right from when I went 'round & 'round
with Access a while ago)
At 03:03 PM 8/12/00 -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.
