[sattua]

hi well i fixed the problem already but I did not found what was wrong, so I'll explain:

i have this cfcomponent, this one:

<cfcomponent displayname="participation_validator" hint="participation in n number of weeks per user">
	
	 <cffunction name="getWeekPerUser" hint="Gets all weeks where a user has played" returntype="numeric">

		<cfargument name="usernid" type="string" required="yes">
		
	   	<cfquery name="getWeekPerUserQuery" datasource="capperscorner" >
		 	select distinct count(week) as nweeks from tablex where account = '#usernid#'
	   	</cfquery>
	
		
	   	<cfreturn getWeekPerUserQuery.nweeks[1]>
	
	 </cffunction>

</cfcomponent>

it's simple, it just return a numeric, this componet is invoke by this code(the whole cfm file is too big, so this is a part):

			<td align="center">
				<cfinvoke component="participation_validator"
					method="getWeekPerUser"
					returnvariable="weekscount">
					
			   		<cfinvokeargument name="usernid" value=#account#>
			   		
				</cfinvoke>
				<cfoutput>#weekscount#</cfoutput>
			</td>

so the problem was that the #weekscount# value into the <cfoutput> tag, printed many times (like in a loop), no idea why, so what I did was take out the #weekscount# value from the <cfoutput> tag, and as I expected, the value only printed once.

The question is; why when the value was into the tag, this one got printed many times? i thought at first "maybe theres a loop somewhere", but when I took the value outside the tag,everything works ok

thx in advance

This post has been edited by sattua: 28 July 2011 - 10:58 AM

[Craig328]

I'm having trouble understanding what you did here:

Quote

so the problem was that the #weekscount# value into the <cfoutput> tag, printed many times (like in a loop), no idea why, so what I did was take out the #weekscount# value from the <cfoutput> tag, and as I expected, the value only printed once

If you can post the code example where you "take out the #weekscount# value from the <cfoutput> tag" that you say ran okay, maybe we can figure it out. From the way you describe it, if you removed the variable from in between the cfoutput tags, nothing should have outputted.

Further, why are your component method returning "getWeekPerUserQuery.nweeks[1]"? Your getWeekPerUserQuery should return a single value as it is an aggregate function value, right? I see you have a distinct in there so maybe I'm a little confused about what you're trying to return with the array notation.

[sattua]

hi thx for reply.

yeah sure, i take out the #weekscount# value from the <cfoutput> tag, I put it like this:

			<td align="center">
				<cfinvoke component="participation_validator"
					method="getWeekPerUser"
					returnvariable="weekscount">
					
			   		<cfinvokeargument name="usernid" value=#account#>
			   		
				</cfinvoke>

				#weekscount#
			
			</td>

this works good. the #weekscount# value prints well. About the componet, well it doesn't matter how it works coz return what I need to get.

In summary : only:

#weekscount#

works ok,

<cfoutput>#weekscount#</cfoutput> 

iterates n number of times.

[Craig328]

If the weekscount is outputting then you have cfoutputs bracketing that code section somewhere. You mentioned what you posted was just a portion because the rest of the page was too big to post. Go to the top of the page and do a ctrl-f (normal shortcut for a Find function) and look for cfoutput.

[xheartonfire43x]

It sounds like you definitely have a <cfoutput query="x" group="y"> somewhere in your code. To better explain what is happening, I will give you an example of a cfoutput loop.

<cfquery name="availableDates">
    SELECT date,month FROM availabledates ORDER BY month
</cfquery>
<select name="dates">
    <cfoutput query="availableDates" group="month">
        <optgroup>#availableDates.month#"</optgroup>
        <cfoutput>
            <option value="#availableDates.date#">#availableDates.date#"</option>
        </cfoutput>
    </cfoutput>
</select>

So what happens is that one loop gives me the month name as an option group. Then I use a nested cfoutput tag to loop through all the values in that month. Using any other nested cfoutput should throw an error so if you are using Eclipse do a regex find of cfoutput([A-Za-z0-9\"\ \=]+)(group=("|')[fdsa]+("|')) and that should find you the grouped cfoutput.

[sattua]

thanks Craig328, xheartonfire43x; for reply, i will take your advices