If this does not work, I would suggest you do soem debugging on the QUERIES.
<td align="left">
<CFSET firstID = getTimeLinesRet.Status_ID>
<select name="StatusID_#TaskID#">
<cfloop query="getStatusRet">
<cfset thisID = getStatusRet.Status_ID>
<option value="#thisID#" <cfif firstID EQ
this_ID>Selected</cfif>>#Status#</option>
</cfloop>
</select>
</td>
Debug Options: (Something similar, not perfect but debugging better than
nothing)
<cfoutput query="getTimeLinesRet">
#getTimeLinesRet.Status_ID# <BR>
DO LOOP:
<cfloop query="getstatusret">
<cfif getstatusret.status_id EQ gettimelinesret.status_id>
THEY MATCH<BR>
<CFBREAK>
<CFELSE>
NO MATCH (#getstatusret.status_id#)<BR>
</CFLOOP>
<BR><BR>GO TO NEXT RECORD <BR><BR>
</CFQUERY>
________________________________
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: Tue 3/13/2007 12:16 PM
To: CF-Talk
Subject: Re: Why is this not working
No bueno.
On 3/13/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> Nature of the beast.
>
> Try this:
>
>
> <td align="left">
> <select name="StatusID_#TaskID#">
> <cfloop query="getStatusRet">
> <cfset thisID = getStatusRet.Status_ID>
> <option value="#thisID#" <cfif
> getTimeLinesRet.Status_ID EQ this_ID>Selected</cfif>>#Status#</option>
> </cfloop>
> </select>
> </td>
>
>
> ________________________________
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272547
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
