CFOUTPUT QUERY rowcount = 0

[jack456]

Hello,

I have a query which return 0 row.
I have a CFOUTPUT QUERY which try to output my query.
Coldfudion enter in the CFOUTPUT once EVEN if my query return 0 row.

Is it correct?
I thougth Coldfusion will never enter in the CFOUTPUT QUERY because the
rowcount is 0 (zero).

Could you confirm please. I try to reach the answer on internet but I found
nothing.

Thanks.

[redevolve]

Yes, it will never enter your <cfoutput query="q"> tag block.
Post your codes to let us check maybe ?

[Dan Bracuk]

You have to check for this in your code.

<cfif query.recordcount is 0>
do something
<cfelse>
do something else

Originally posted by: jack456
Hello,

I have a query which return 0 row.
I have a CFOUTPUT QUERY which try to output my query.
Coldfudion enter in the CFOUTPUT once EVEN if my query return 0 row.

Is it correct?
I thougth Coldfusion will never enter in the CFOUTPUT QUERY because the
rowcount is 0 (zero).

Could you confirm please. I try to reach the answer on internet but I found
nothing.

Thanks.

[jack456]

First, Thank both for answer.

I found the problem.
In debug mode the query return 0 row BUT little far away there is an
"QueryAddRow"! It's why Coldfusion enter in the cfoutput tag.

Now I have to found WHY there is an QueryAddRow but this is another story!

Thanks anymay.