Oops misunderstood the docs on QueryAddRow... was a bit late last night
when I did it :-)
thought the number was what number of row you were adding to as opposed
to the number of rows that you wanted to add!
Again, cheers
-----Original Message-----
From: Raymond Camden
Sent: 31 July 2003 12:59
To: CF-Talk
Subject: RE: Help with a pesky UDF...
By the way, when you do your queryAddRow, why do you use 2 and 3? I
think you meant to only add one row at a time.
========================================================================
===
> -----Original Message-----
> From: David Collie (itndac)
> Sent: Thursday, July 31, 2003 5:23 AM
> To: CF-Talk
> Subject: Help with a pesky UDF...
>
>
> 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#">
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
