> 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
Are you running a relational query? That is are you grabbing data from two
tables?
If so you need to do something like this to remove dupliucates:
SELECT CuisineTable.CuisineID, CuisineTable.Cuisine
FROM CuisineTable, Restaurants
WHERE CuisineTable.CuisineID = Restaurants.CuisineID
Try sending your query to the list.
HTH,
Duane Boudreau
Director, Web Technologies
Ektron, Inc.
------------------------------------------------------------------------------
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.
