You can use cfselect
<cfquery name="getCar"...>
select car_man from...
</cfquery>
<cfselect name="car"
size="0"
query="getCar"
value="car_man"
display="car_man"
selected="#car_man#"
multiple="no">
</cfselect>
you can do the same thing with a normal select but you have to manually loop
over your query
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm
----- Original Message -----
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, June 30, 2002 4:25 PM
Subject: dynamic select
> I have a query that pulls options to populate a select box, now what I
> need to do is have a select that makes one of the values of the select
> box "SELECTED" if it's value is in my inventory table from a second
> query.
>
> IE:
>
> query of inventory returns the value of ford for the make column...
>
> I need this to happen, whats the best way to do it.
>
>
> <select name="make">
> <option value="chevy">Chevy
> <option value="honda">Honda
> <option value="ford" SELECTED>Ford
> </select>
>
>
>
>
> Douglas Brown
> Email: [EMAIL PROTECTED]
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
