the following is the code in question and the error.... HALLLLLLLP!!!
<cfquery name="qry_getProjectInfo" datasource="#application.dsn#">
SELECT *
FROM tbl_project
WHERE UserID = #LoginResults.UserID#
</cfquery>
<cfif #LoginResults.recordcount# is not 0>
<!--- this array works --->
<cfset application.UserSet=ArrayNew(1)>
<cfoutput query="LoginResults">
<cfset application.UserSet[1] = #ProjectURL#>
<cfset application.UserSet[2] = #UserID#>
</cfoutput>
<!-- end working array --->
<!--- this array doesn't work --->
<cfset application.ProjectSet=ArrayNew(3)>
<cfoutput query="qry_getProjectInfo">
<cfset
application.ProjectSet[ArrayLen(application.ProjectSet)+1][1]="#qry_getProjectInfo.projectID#">
<cfset
application.ProjectSet[ArrayLen(application.ProjectSet)][2]="#qry_getProjectInfo.name#">
<cfset
application.ProjectSet[ArrayLen(application.ProjectSet)][3]="#qry_getProjectInfo.url#">
</cfoutput>
<!--- end fubar array ---->
<!--- The error code --->
A scalar value of type java.lang.Integer cannot be assigned to a 2-dimensional ColdFusion array.
A ColdFusion 2-dimensional array can only hold 1-dimensional ColdFusion arrays and Java List objects.
The error occurred in C:\CFusionMX\wwwroot\core\actions\act_login.cfm: line 23
21 : <cfset application.ProjectSet=ArrayNew(3)>
22 : <cfoutput query="qry_getProjectInfo">
23 : <cfset
application.ProjectSet[ArrayLen(application.ProjectSet)+1][1]="#qry_getProjectInfo.projectID#">
24 : <cfset
application.ProjectSet[ArrayLen(application.ProjectSet)][2]="#qry_getProjectInfo.name#">
25 : <cfset
application.ProjectSet[ArrayLen(application.ProjectSet)][3]="#qry_getProjectInfo.url#">
Scott Stewart
Web Application Developer, AMTI
AIR-520
(202)-385-4545
Brainbench Certified Cold Fusion 4.5
Brainbench Certified HTML 3.2
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
