[thelist] Nested CFOUPUT Problem (Need help fast!)

How do I call the result of one query from within another? Right now 
I'm getting nested output issues.

I have a product table that has the id of a supplier from another 
table. What I want is that if the supplierID  in the products table 
matches the supplier's ID (from the query) that the option is 
selected.

Here's what I have

<select name="someName">
<option>Choose...</option>
<cfoutput query="getSupplier">

<option value="#ID#"
    <cfif #ID# eq #getProducts.SupplierID#>Selected</cfif>
>#Company#

</option>

</cfoutput>
</select>

By the way, the breaks are just for email wrapping. The queries of 
course call for the correct information (and get it).

Thanks in advance to those kind enough to help me with this one. It's 
a deadline task.
-- 


Frank Marion                      Loofah Communications
frank@loofahcom.com               http://www.loofahcom.com