> On 10/27/06, Peter Tilbrook <[EMAIL PROTECTED]> wrote: > > If a CFQUERY returns no records it does not exist so there is no way > to test for "zero" records as no result is produced. > > > > That's incorrect: > > <cfquery datasource="myDS" name="QTest"> > SELECT * > FROM sometable > WHERE 1=0 > </cfquery> > <cfoutput>#QTest.RecordCount#</cfoutput> > > The output is 0. You can get the columnlist too. > -- > CFAJAX docs and other useful articles: > http://www.bifrost.com. au/blog/
got your point about that so even if the result is zero it is still true so what's the alternative i could do so that when it is zero it prints a message ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
