Check recordcount first.
<cfif queryname.recordcount eq 0>
<cfset qPaymentsRecievedSum.PSum = 0>
</cfif>
--Max
qPaymentsRecievedSum.PSum
Tim Starling <[EMAIL PROTECTED]> wrote:
Tim Starling <[EMAIL PROTECTED]> wrote:
No, the error occurs when there is no record returned. Here is an example
of one of the queries:
SELECT SUM(apayments.Amount) AS PSum FROM apayments, trip, aregistration
WHERE (((trip.ID = apayments.TripID) AND (aregistration.TripID =
apayments.TripID)) AND ((apayments.AffiliateID = #Session.MM_UserID#) AND
((apayments.PostStatus = 2) AND ((apayments.Type = 2) AND (aregistration.ID
= #URL.recordID#)))))
I take the output from this query and several others and add or subtract
based on what I am trying to get. If no records are returned, I get an
error because qPaymentsRecievedSum.PSum has no value and CF tells me that it
can't convert "" to a number to perform the calculation.
I thought thatthis
would do it but it apparently doesn't.
Thanks for the help.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Jamie Babineaux
Sent: Monday, June 13, 2005 2:20 PM
To: [email protected]
Subject: RE: Query
Would this be a case where in your query you add
something like "where 1=1" so that you always get a
recordset returned?
--- "Knipp, Eric" <[EMAIL PROTECTED]>wrote:
> 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: Whe n I run a
> query to get a sum, if
> there is no value returned, set the value to 0.
> I've triedand 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.
>
"polyma th \POLL-ee-math\, noun:
A person of great or varied learning; one acquainted with various subjects
of study."
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
----------------------------------------------------------
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
----------------------------------------------------------
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
