If the query is executing correctly but bringing back no records, this should work with blahname.recordcount equal zero . If the query is not executing correctly, blahname.recordcount will not equal zero.
On Wed, Mar 31, 2010 at 10:59 AM, 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:332503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm