Hello.
I have these three queries that I am creating below. The first two work
great, but the third one gives me the following error:
The row number, (1920) is out of bound. This is happening on line 48 which
is this one:
<cfset temp = QuerySetCell(yearQuery, "year_num", #yearnumber[year_number]#,
#year_number#)>
What is wrong with it? Seems to me it should work.
<cfset monthQuery = QueryNew("Month_Number, Month_Name", "Integer,
varchar")>
<cfset newRow = QueryAddRow(monthQuery, 12)>
<cfloop index="loopcount" from=1 to=12>
<cfset months[loopcount]=MonthAsString(loopcount)>
<cfset monthNumber[loopcount] = loopcount>
<cfset temp = QuerySetCell(monthQuery, "Month_Number",
#monthNumber[loopcount]#, #loopcount#)>
<cfset temp = QuerySetCell(monthQuery, "Month_Name", #months[loopcount]#,
#loopcount#)>
</cfloop>
<cfset dayQuery = QueryNew("Day_Number", "Integer")>
<cfset newRow = QueryAddRow(dayQuery, 31)>
<cfloop index="loopcount" from="1" to="31">
<cfset dayNumber[loopcount] = loopcount>
<cfset temp = QuerySetCell(dayQuery, "Day_Number",
#dayNumber[loopcount]#, #loopcount#)>
</cfloop>
<cfset yearQuery = QueryNew("year_num", "Integer")>
<cfset newRow = QueryAddRow(yearQuery, 100)>
<cfloop index="year_number" from="1920" to="2020">
<cfset yearnumber[year_number] = year_number>
<cfset temp = QuerySetCell(yearQuery, "year_num",
#yearnumber[year_number]#, #year_number#)>
</cfloop>
Thanks,
Bruce Sorge
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265280
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
