Ok, found the cause of the issue, by taking the query into SQL Server

In SQL,  the following is being returned

*Warning: Null value is eliminated by an aggregate or other SET operation.

(0 row(s) affected)*

So it appears this is what is throwing off the query results in CF

I am working on resolving this issue now.

-Dave

On Wed, Mar 31, 2010 at 2:18 PM, Robert Harrison <rob...@austin-williams.com
> wrote:

>
> You are correct that it should work, but they maybe something else in the
> code which is preventing the query from being executed. On the top of your
> page add:
>
>        <cfparam name=" blahName.recordcount" default="0">
>
> And that will deal with the case where the query is not executed.
>
> Robert B. Harrison
> Director of Interactive Services
> Austin & Williams
> 125 Kennedy Drive, Suite 100
> Hauppauge NY 11788
> P : 631.231.6600 Ext. 119
> F : 631.434.7022
> http://www.austin-williams.com
>
> Great advertising can't be either/or.  It must be &.
>
> Plug in to our blog: A&W Unplugged
> http://www.austin-williams.com/unplugged
>
>
> -----Original Message-----
> From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com]
> Sent: Wednesday, March 31, 2010 1:59 PM
> To: cf-talk
> Subject: CFQUERY Question
>
>
> I'm running into an odd behavior with CFQUERY (at least I think it is odd)
>
> I have the following code (example)
>
> <cfquery name="blahName" datasource="blah">
>   SELECT blah
>     FROM blah
>   WHERE blah = 1
> </cfquery>
>
> <CFIF blahName.recordCount GT 0>
>   12345
> </CFIF>
>
> if the query blahName returns no results, I thought i would still be able
> to
> access blahName.recordCount....
>
> Am I wrong on this, or is there something else I am overlooking?
>
> Thanks
> -Dave
>
>
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332502
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to