That was easy. Thanks Bob
>From: "Bob Silverberg" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: LOOP AND VARIABLE QUESTION
>Date: Mon, 11 Dec 2000 17:17:15 -0500
>
>If you want ThisVar to contain the value stored in Client.lr#numvar#, then
>I
>think you need to do an Evaluate on it. Otherwise ThisVar is going to be
>equal to "Client.lr1". Also (although this wouldn't be causing a problem)
>you don't need those # signs inside your <CFIF> tag.
>
>Bob
>
>-----Original Message-----
>From: S R [mailto:[EMAIL PROTECTED]]
>Sent: December 11, 2000 4:59 PM
>To: CF-Talk
>Subject: LOOP AND VARIABLE QUESTION
>
>
>I have this loop below pulling from a database. As you can see, the
><select>
>part of the loop does exactly what I want it to. It dynamically creates
>lr1,
>lr2, lr3, lr4, lr5, etc. The problem I am now having is where the <CFIF>
>statement is. I need that to do exactly what the <CFIF> statement is
>telling
>it to do but it does not. Right now, each module automatically defaults to
>choice 1 because the #id# and/or #ThisVar# variable is not being fed to the
>CFIF statement. How can I accomplish this??
>
>Sal
>
><CFSTOREDPROC datasource="#application.Datasource#"
>dbname="UserPreferences"
>procedure="GetChoices">
><cfprocresult name="GetChoices">
></CFSTOREDPROC>
>
><CFSTOREDPROC DATASOURCE="#application.datasource#"
>DBNAME="UserPreferences"
>PROCEDURE="sp_GetLRCount">
><CFPROCRESULT NAME="GetLRCount">
></CFSTOREDPROC>
>
><CFSET LeftLoop = #GetLRCount.LRNumber#>
>
><CFLOOP INDEX="i" FROM="1" TO="#LeftLoop#">
>
><CFSET numvar = i>
><CFSET ThisVar = "Client.lr#numvar#">
>
><cfoutput><select name="lr#i#"></cfoutput>
><cfoutput query="GetChoices">
>
>
><option value="#id#" <cfif #id# is
>#ThisVar#>SELECTED</CFIF>>#ChoiceName#</option>
></cfoutput>
></select>
>
><p>
>
></CFLOOP>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists