You are correct, the record count for an empty query object does exist (and should be 0). What exactly is not working? Are you getting an error message?
On Wed, Mar 31, 2010 at 1:59 PM, Dave Sueltenfuss <dsueltenf...@gmail.com>wrote: > > 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:332500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm