On 9/14/00, W Luke penned:
><cfquery name="findcats" datasource="localads">
> SELECT ID, cat_id, cat_name, sub_name FROM categories, sub_categories
> ORDER by cat_name
> </cfquery>
Try:
<cfquery name="findcats" datasource="localads">
SELECT ID, cat_id, cat_name, sub_name
FROM categories c, sub_categories s
WHERE c.cat_id = s.cat_id
ORDER by cat_name
</cfquery>
>
> <CF_TwoSelectsRelated
> QUERY="findcats"
> NAME1="Cat"
> NAME2="Selected"
> DISPLAY1="cat_name"
> DISPLAY2="sub_name"
> VALUE1="cat_id"
> VALUE2="sub_name"
Just curious. Wouldn't you want value2 to be sub_id. It should work
if you change the query though. And I presume you remembered to put
name="MyOtherForm" in the form header.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
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.
