The following code below can be seen at

http://www.tcmtests.com/files/codetest.cfm

When I try append the following code to it I get an error that the variable Sleep is not defined

<cfouput>#Score.Sleep#</cfoutput>

How can I output the structure key value that I want?

---------------

<cfquery name="GetAverages">
select AVG(QuizPercent) as AvgPercent, QuizID  from test_board_biomed
GROUP BY QuizID
</cfquery>

<cfdump var="#GetAverages#" label="new">

<cfset Score = StructNew()>

<cfoutput query="GetAverages">
<cfset Result = StructInsert(Score,QuizID,AvgPercent)>
</cfoutput>

<cfoutput>Count: #StructCount(Score)#</cfoutput>

<cfloop collection="#score#" item="x">
<cfoutput>#x# #Score[x]#</cfoutput><br>
</cfloop>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to