RE: Query

[Tim Starling]

I want to perform some other calculations on the results of the sum and I get errors that it can’t convert “” to a number.  How would I use RecordCount to help me do that?  Sorry, this is probably a rookie mistake.   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Knipp, Eric Sent: Monday, June 13, 2005 2:16 PM To: 'list@dfwcfug.org' Subject: RE: Query   I guess this means this is the behavior when there are no records in the table?  Couldn't you just check the RecordCount property, and go from there? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tim Starling Sent: Monday, June 13, 2005 2:14 PM To: list@dfwcfug.org Subject: Query How would I best do the following:  When I run a query to get a sum, if there is no value returned, set the value to 0.  I've tried <cfparam> and it doesn't seem to work - I guess it considers null a value.   Thanks, Tim       CONFIDENTIALITY NOTICE: The information contained in this e-mail and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this e-mail in error, please immediately notify the sender and delete it from your system.