Click to See Complete Forum and Search --> : Error with array inside query loop


Aaronyman
02-16-2011, 10:00 AM
<cfset var LOCAL = {}>

<cfquery name="qrysecnavtop" datasource="dev">

SELECT pagename, subname, maincontent FROM ECpages
WHERE navplacement = 2
ORDER BY sortorder

</cfquery>

<cfset secnavtopboxstring=ArrayNew(1)>
<cfset secnavbottomboxstring=ArrayNew(1)>
<cfset LOCAL.count = 0>

<cfloop query="qrysecnavtop">
<cfset LOCAL.count++>

<cfset secnavtopboxstring[count]&= '<span>#qrysecnavtop.pagename#</span>#qrysecnavtop.subname#'>
<cfset secnavbottomboxstring&= '#qrysecnavtop.maincontent#'>


</cfloop>


I keep getting this error....why?

The element at position 1 cannot be found.

The error occurred in C:\inetpub\wwwroot\ECDevSite\content.cfc: line 55

53 : <cfset LOCAL.count++>
54 :
55 : <cfset secnavtopboxstring[count]&= '<span>#qrysecnavtop.pagename#</span>#qrysecnavtop.subname#'>
56 : <cfset secnavbottomboxstring&= '#qrysecnavtop.maincontent#'>

Aaronyman
02-16-2011, 10:24 AM
problem resolved

it seems like:
secnavtopboxstring[1] was undefined

WolfShade
02-16-2011, 11:41 AM
Sorry I didn't see this, earlier.

I was thinking that because arrays are zero-based index and you started inserting at the second position ([1]) that might have had something to do with it.

Glad you figured it out.

^_^

Aaronyman
02-16-2011, 06:55 PM
Actually array's start at an index of 1 in Coldfusion I think