Hello all,
Having problems with the following UDF and need a little bit of help if
possible.... running CF5 btw on IIS 5
Everything runs fine as the code is below, but as soon as I move the
debug comments inside the second 'for' loop but before the 'if'
statement, the page just hangs and kills the thread.... it just doesn't
seem to want loop over the count of the query...
I can't see a reason why it shouldn't work.... Code as follows with test
query...
<cfscript>
theQuery = QueryNew("STATUS,COUNT");
QueryAddRow(theQuery, 1);
QuerySetCell(theQuery, "STATUS", "A", 1);
QuerySetCell(theQuery, "COUNT", "3", 1);
QueryAddRow(theQuery, 2);
QuerySetCell(theQuery, "STATUS", "C", 2);
QuerySetCell(theQuery, "COUNT", "2", 2);
QueryAddRow(theQuery, 3);
QuerySetCell(theQuery, "STATUS", "O", 3);
QuerySetCell(theQuery, "COUNT", "7", 3);
</cfscript>
<cfdump var="#theQuery#">
<cfscript>
function udfMakeStatus(q) {
var i = 1;
var j = 1;
var count = 0;
var text = "";
var code = "";
var lStatus =
"O,Offered,R,Rejected,A,Accepted,C,Confirmed,F,Finished";
var rHTML = "<em>OFFER STATUS</em> |";
for (i=1; i LTE ListLen(lStatus); i=i+2) {
count = 0;
text = ListGetAt(lStatus, i+1);
code = ListGetAt(lStatus, i);
if (IsQuery(q) AND q.RecordCount GT 0) {
writeoutput("text=" & text & " - code=" & code &
" - rc=" & q.RecordCount & "<br />");
/*
for (j=1; j LTE q.RecordCount; j+1) {
writeoutput("text=" & text & " -
code=" & code & " - j=" & j & "<br />");
if (q.STATUS[j] EQ code) {
count = q.COUNT[j];
}
}
*/
}
rHTML = rHTML & " " & text & " - " & count
& " |";
}
rHTML = rHTML & "";
return rHTML;
}
writeoutput(udfMakeStatus(theQuery));
</cfscript>
I'm expecting an output (without the writeoutput's) of....
'OFFER STATUS | Offered - 7 | Rejected - 0 | Accepted - 3 | Confirmed -
2 | Finished - 0 |'
I've been tearing my hair out with it and I want it to work... or at
least know why it doesn't work :-)
Cheers in advance
DC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
