I got it. It's kinda funkadelic.
<cfloop from='1' to='#lineNum#' index='i'>
<cfquery datasource="#dsn#">
insert into tbllog (log_name, log_time, log_problem, log_linenum,
log_sourcetext, log_directoryfile, log_suggestion)
values(
'#form.scanname#'
,
<cfqueryparam cfsqltype="cf_sql_timestamp"
value="#createODBCDateTime(now())#">
,
<cfloop from='1' to='#arrayLen(errorArray[i])#' index='j'>
<cfset nCtr = nCtr + 1>
<!--- <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'>
<cfif len(errorArray[i][j][k][l][m][n])>
<cfif n eq 2>
<cfqueryparam cfsqltype="cf_sql_integer"
value="#errorArray[i][j][k][l][m][n]#">
<cfelse>
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#errorArray[i][j][k][l][m][n]#">
</cfif>
<cfelse>
NULL
</cfif>
<cfif n neq arrayLen(errorArray[i][j][k][l][m])>
,
</cfif>
<!--- <cffile action="append" file="#form.logPath#" addnewline="yes"
output="#errorArray[i][j][k][l][m][n]#"> --->
</cfloop>
</cfloop>
</cfloop>
</cfloop>
</cfloop>
)
</cfquery>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:308280
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
