Selected is not working!!! help please!

[alecken]

The item on my drop down list is not selected correctly and all show the first
item.
Is this because I use <cfloop query=""> instead of <cfoutput query="">
surrounding the select tags?
I can't use 2 <cfoutput> nested within each other since it will generates
error that's why I'm using <cfloop> instead.
Otherwise why this code does not work??? it seems so simple, please help!
<select name="InfoList">
<cfloop query="getAllInfo">
<option value="#InfoID#" <cfif #Bgs.Info# EQ
#getAllInfo.InfoID#>Selected</cfif>>#Name# <<<< this always select 1st item
</cfloop>
</select>

HERE IS THE BIGGER PICTURE:

<cfquery name="Bgs" datasource="wbt">
Select * From BgTr <cfif IsDefined("url.lc")> where AppID =
#URL.Lc#</cfif>
</cfquery>

<cfoutput query="Bgs">

[Dan Bracuk]

Since you didn't specify a row number for getAllInfo here:
<cfif #Bgs.Info# EQ #getAllInfo.InfoID#>

you always get the first record. By the way, you don't need octothorps inside a cfif tag.

[alecken]

Hi!
Row number? can you provide example? I always do like what I did without row number and never had problem.

[Dan Bracuk]

this
<cfif #Bgs.Info# EQ #getAllInfo.InfoID#>
should be this
<cfif Bgs.Info EQ getAllInfo.InfoID[currentrow]>


Originally posted by: alecken
Hi!
Row number? can you provide example? I always do like what I did without row
number and never had problem.

[reenaroy]

Hi Alecken,

Instead of using this ..

<select name="InfoList">
<cfloop query="getAllInfo">
<option value="#InfoID#" <cfif #Bgs.Info# EQ
#getAllInfo.InfoID#>Selected</cfif>>#Name# <<<< this always select 1st item
</cfloop>
</select>


use this .............

<cfset BgsInfo=trim(Bgs.Info)>
<cfset getAllInfoInfoID=trim(getAllInfo.InfoID)>

<select name="InfoList">
<cfloop query="getAllInfo">
<option value="#getAllInfo.InfoID#" <cfif BgsInfo EQ
getAllInfoInfoID>Selected</cfif>>#getAllInfo.Name# </option>
</cfloop>
</select>