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
