Query of Query count(column) returns blank not zero

> This appears to be a bug.

Yep.

> Query of Query count(column) returns blank not zero when there are no matches.
> With matches works fine.
>
> e.g. select count(i_id) from PersonnelQuery where i_id < 100
>
> Where does one report these?

Just FYI... I've made sure the Adobe bods on the CF9 programme are aware of
this. UInfortunately I cannot relay back what action is being taken, or
even *if* any action is being taken (I've signed the usual NDA carry-on),
but they're aware of it.

Cheers for bringing this up.

--
Adam

Azadi, yes, thanks for the link. I logged it. It has to be such a simple fix I can't believe that it's been years.

Bob - my workaround was probably less annoying to do. I do a select of any column and then used QofQ.RecordCount instead of the QofQ.countqueryvariable

didn;t mean to be rude at all. and i did provide a link to report it.

on a second thought, it is a bit strange, but then cf QoQ's support only
limited SQL...

no, you are right, i would expect that QoQ to return a row, too...


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

Thank you for your quick rude response. They are not nulls. Did I say nulls? I said no records match the query. That results in a zero in every database I've used in the last 25 years. So are you still telling me this is normal query behavior?

report what? normal query behaviour? no matter how many NULLs you count
the result will still be... NULL!

you can do a QoQ recordcount check before processing results of your QoQ
to make sure it has actually returned a result.

but if your sure you want to report this, go to
http://www.adobe.com/go/wish/


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/