Ah, so you're performing other calculations in the same query?
Do you have a code sample?
Tim Starling wrote:
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:* '[email protected]'
*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] Behalf Of *Tim Starling
*Sent:* Monday, June 13, 2005 2:14 PM
*To:* [email protected]
*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. **
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
