its a pretty bug IF though, is there rumours banting around that it is to become a typed language...
-----Original Message----- From: Stephen Moretti [mailto:stephen@;cfmaster.co.uk] Sent: 31 October 2002 14:07 To: CF-Talk Subject: Re: basic question - testing for no reuslts from query Neil!!! Slap wristies!!! ;o) > or just : > > <cfif query.recordcount> > record count is numeric not boolean! Yes OK, so CF isn't typed _yet_ and will take anything other than 0 to be true, but it would be better to write it correctly, so your application is more readable and won't fall over if CF does become a typed language! > or you could use ListLen(ValueList(query,",")) > What for? You've already got the value of listlen in recordcount. Tim, Just a suggestion. If you have a look at the online docs for CFQuery (either at MM, in CFStudio or possibly on your server) you'll see that the description tells you the additional fields that are returned with a query. CFQUERY returns ExecutionTime, recordcount, columnlist and currentrow, as well as the contents of your query. Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
