When I was makeing a smaller sample I noticed my own Error on the Query
Object
<cfset qExcel = QueryNew("field1, field2, field3, field4")>
<!--- doing this before my loop even started is not really good --->
<cfset newRow = QueryAddRow(qExcel, 1)>
<cfloop from="1" to="#maxRow#" index="i">
<cfloop from="1" to="4" index="iCol">
<cfset dummy = QuerySetCell(qExcel, "field#iCol#", "Value_#i#",
iRow) />
</cfloop>
*<cfset newRow = QueryAddRow(qExcel, 1)>*<!--- Doing this after
QeerySetCell and before I break out of the loop will add en Empty row --->
<cfoutput>Row ###iRow# Added</cfoutput><br />
<cfif iRow IS maxRow><cfbreak></cfif>
<cfset iRow = iRow + 1 />
</cfloop>
Sorry, this was my logic that was messed up...
So I'll try to make a simpel sample of the Excel issue insted.
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
