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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm