Does your database have the COALESCE function? I've used this a lot in queries to return a 0 instead of null, works great. It returns the first non-null value in a list of values.
COALESCE(field, 0) field=NULL -- returns 0 field<>NULL -- returns field -----Original Message----- From: Tim Starling [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 2:32 PM To: [email protected] Subject: RE: Query I thought that <cfparam name="qPaymentsRecievedSum.PSum" default="0"> this would do it but it apparently doesn't. ---------------------------------------------------------- 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
