Michael, I've been bit by the mySQL count being character. It happens with a simple "select count(*) from table". CAST, etc doesn't fix it.
I don't know if it is mySQL or the ODBC driver. Larry At 08:28 AM 2007-05-01 -0400, you wrote: >Dave Crozier wrote: > > 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? > > >nAmount is defined as a decimal(8,2). > >-- >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.
