>You need to add the indexes to your output loops:
>
Barney, I did ok appending a text file with the columns of values of the
innermost array, but I'm havin a hard time convert it to a query row. I'm
gettin a column count doesnt match error.
<cfquery datasource="#dsn#">
insert into tbllog (log_name, log_time, log_problem, log_linenum,
log_sourcetext, log_directoryfile, log_suggestion)
values(
<!--- <cffile action="append" file="#form.logPath#" addnewline="yes" output="
Scan Performed: #DateFormat(now(), "m/dd/yyyy")# #TimeFormat(now(), "h:mm
tt")#
Page: #name#
"> --->
<cfloop from='1' to='#lineNum#' index='i'>
<cfloop from='1' to='#arrayLen(errorArray[i])#' index='j'>
<!--- <cffile action="append" file="#form.logPath#" addnewline="yes"
output="******************************************************************************************************">
--->
<cfloop from='1' to='#arrayLen(errorArray[i][j])#' index='k'>
<cfloop from='1' to='#arrayLen(errorArray[i][j][k])#' index='l'>
<cfloop from='1' to='#arrayLen(errorArray[i][j][k][l])#' index='m'>
<cfloop from='1' to='#arrayLen(errorArray[i][j][k][l][m])#' index='n'>
<cfset nCtr = nCtr + 1>
<cfloop from="1" to="#arrayLen(errorArray[i][j][k][l][m][n])#"
index="thisItem">
<cfif len(errorArray[i][j][k][l][m][n])>
<cfif not isNumeric(errorArray[i][j][k][l][m][n])>
<cfqueryparam value="#errorArray[i][j][k][l][m][n]#">
<cfelse>
<cfqueryparam cfsqltype="cf_sql_integer"
value="#errorArray[i][j][k][l][m][n]#">
</cfif>
<cfelse>
NULL
</cfif>
<cfif not nCtr eq 5>
,
</cfif>
</cfloop>
<!--- <cffile action="append" file="#form.logPath#" addnewline="yes"
output="#errorArray[i][j][k][l][m][n]#"> --->
</cfloop>
</cfloop>
</cfloop>
</cfloop>
</cfloop>
</cfloop>
)
</cfquery>
Thanks much,
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308279
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
