Populating SELECTED of CFSELECT with different query

[ThomasWood]

I am trying to populate a CFSELECT from a query (which is working fine), but I
want the SELECTED value to come from a
different query. The values are identical because the second table is
populated with values from the first table on a seperate page. Is there anyway
to do this? Basically this is what I want to do

<cfquery name="query1">
SELECT * FROM Table1
</cfquery>

<cfquery name="query2">
SELECT * FROM Table1
WHERE Name = '#query1.Name#'
</cfquery>

<cfselect query="table1" display="Name" value="Name" selected="#query2.Name#">

I know that you cannot use multiple queries, but I know there must be a way to
do this, but I can't think of how.

[ThomasWood]

Took care of it like this

<cfselect name="selectname">
<cfloop query="query1">
<cfif query1.tablename EQ query2.tablename>
<option Value="<cfoutput>#query2.name#</cfoutput>"
selected><cfoutput>#Name#</cfoutput></option>
<cfelse>
<option
Value="<cfoutput>#query2.name#</cfoutput>"><cfoutput>#Name#</cfoutput></option>
</cfif>
</cfloop>
</cfselect>