sorry :-) I like to use and abuse it "typelessness"
-----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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
