Since the two tables don't seem to be related you should probably run two
separate queries
<cfquery name="query1" datasource="#dsn#">
SELECT DISTINCT
CuisineData.CuisineID,
CuisineData.Cuisine
FROM CuisineData
</cfquery>
<cfquery name="query2" datasource="#dsn#">
SELECT DISTINCT
CityData.CityID,
CityData.City
FROM CityData
</cfquery>
>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
>
------------------------------------------------------------------------------
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.
