Michael, DOH! Just a matter of interest, have you tried "0+sum(P1.nAmount) as nSum"?
As for why it is happening I've no idea. How is the nAmount field defined? Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 01 May 2007 12:52 To: [email protected] Subject: Re: [NF] Problem with MySQL COUNT syntax Dave Crozier wrote: > Michael, > Have you tried NVL() as opposed to isnull() > > Dave -- it's MySQL, so it's not NVL, but IFNULL. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
