Arrays in Cold Fusion

Guest_imported · May 13, 2002

I am new to Cold Fusion and trying to learn how to work with arrays.

Please advise what I am doing wrong with this array.

[tt]

<html>
<head>
<title>Learning Arrays in Cold Fusion</title>
</head>

<body>
<cfquery name="myq" datasource="database">
select firstname,department_id,salary
from Employees
</cfquery>

<cfoutput query="myq">
<cfset firstname = myq.ArrayNew(1)>
<cfset firstname[1] = #myq.firstname#>
<cfset firstname[2] = #myq.firstname#>
<cfset firstname[3] = #myq.firstname#>
<cfoutput>#myq.firstname[2]</cfoutput>

</body>
</html>
[/tt]

CFDude · May 13, 2002

You are creating your array inside the cfoutput, so it is getting overwritten. Set it right before your <cfoutput query="myq"> and see if that fixes your problem.

Also, you have another <cfoutput> inside the first <cfoutput> which will cause a nesting error.

try

<cfset firstname = myq.ArrayNew(1)>
<cfoutput query="myq">
<cfset firstname[1] = #myq.firstname#>
<cfset firstname[2] = #myq.firstname#>
<cfset firstname[3] = #myq.firstname#>
</cfoutput>

<cfoutput>#myq.firstname[2]</cfoutput>

Guest_imported · May 13, 2002

First, why are you creating the array in the "myq" namespace?. Why not just:

<cfset firstname = ArrayNew(1)>

Second, why are you assigning myq.firstname to three elements of the array for each record in the query? Are you expecting only ONE record to be returned by the query? When the loop has completed,

Also, get rid of the extra pound signs. They are unnecessary and make the code harder to read. Generally, when referencing variables, you do not need pound signs inside the <cfset> tag or inside ColdFusion functions, except when the variable is also between quotes (as in IsDefined() or TO="#ArrayLen(myarray)#".

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Arrays in Cold Fusion

Guest_imported

New member

CFDude

Programmer

Guest_imported

New member

Similar threads

Part and Inventory Search

Sponsor