its all good, I saw that...just didn't want the already confused soul to get more confused....
get some sleep man. later. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -----Original Message----- From: Clint Tredway [mailto:ctredway@;fishermenstudios.com] Sent: Thursday, October 31, 2002 8:44 AM To: CF-Talk Subject: RE: basic question - testing for no reuslts from query Ya, that's what I get for thinking on no sleep.. I corrected it :) -----Original Message----- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Thursday, October 31, 2002 7:38 AM To: CF-Talk Subject: RE: basic question - testing for no reuslts from query clint. this is the opposite of what he wanted, and doesn't make sense....check your logic :) <cfif query.recordcount gt 0 no records found <cfelse display records </cfif should be <cfif query.recordcount gt 0 display records <cfelse none to show </cfif Happy Halloween Everyone! tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -----Original Message----- From: Clint Tredway [mailto:ctredway@;fishermenstudios.com] Sent: Thursday, October 31, 2002 8:30 AM To: CF-Talk Subject: RE: basic question - testing for no reuslts from query <cfif query.recordcount gt 0 no records found <cfelse display records </cfif HTH -----Original Message----- From: Tim Laureska [mailto:hometeam@;goeaston.net] Sent: Thursday, October 31, 2002 7:27 AM To: CF-Talk Subject: basic question - testing for no reuslts from query I'm ashamed to say I've been banging my head on this for an hour. what is a simple way to code a statement that displays a message when a query produces no results.. like: <CFIF.blah, blah> NO RESULTS <cfelse> #RESULTS# <CFIF> I'm looking for what the "blah, blah" would be?? Tim Laureska ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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