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

Frank,

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

#queryname.fieldname#

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

Where exactly are things going wrong?

Can I see the queries?


If I have a query ("getthem"), and I'm matching it with a URL variable from the
query string, I'd do something like this:

	<cfif #getthem.whateverid# is #url.whateverid#>selected</cfif>

If I had a query ("onesupplier") which returned one row, and my full query was
"allcatfoodsuppliers", then my code would be:

	<cfoutput query="allcatfoodsuppliers">
	<option value="#id#
	<cfif #supplierid# is #onesupplier.supplierid#>selected</cfif>
	>#suppliername#</option>
	</cfoutput>

Perhaps the problem is that there are multiple products in the select element
with the supplierid in question?

More details would be great.


isaac