there is a way under MySql to in your select statements to deal with
null to 0 issue, i can make your selects big and i usually move the
select to a view when i do this
you can use coalesce
select coalesce(amassemblyjobone,0), ...
what coalesce does is pick the first non-null from the comma-sep list
in parens
Ben
On Jun 18, 2007, at 8:46 AM, David Mark Weiss wrote:
You were right, Null values going in, messed up the math. Fixed that
and its working great.
Thanks
Mark
On Jun 17, 2007, at 8:07 PM, William M. Conlon wrote:
maybe you have NULL in some rows. I'm not sure how a NULL is
treated in the
arithmetic.
--
Bill
---------- Original Message -----------
From: David Mark Weiss <[EMAIL PROTECTED]>
To: [email protected]
Sent: Sun, 17 Jun 2007 19:01:18 -0700
Subject: Witango-Talk: MYSQL and Witango
Hi,
I am using Witango with MySQL ENGINE=MyISAM DEFAULT CHARSET=latin1;
I have the following Query.
select rowid,patrolname,patrolletter,entrydate, (amassemblyjobone +
amassemblyjobtwo + amassemblyjobthree + amassemblygroupone +
amassemblygrouptwo + amassemblygroupthree + amactivitiesjobone +
amactivitiesjobtwo + amactivitiesjobthree + amactivitiesgroupone +
amactivitiesgrouptwo + amactivitiesgroupthree + pmactivitiesjobone +
pmactivitiesjobtwo + pmactivitiesjobthree + pmactivitiesgroupone +
pmactivitiesgrouptwo + pmactivitiesgroupthree + eveactivitiesjobone
+ eveactivitiesjobtwo + eveactivitiesjobthree +
eveactivitiesgroupone + eveactivitiesgrouptwo +
eveactivitiesgroupthree) from parthirty where patrolletter = '<@ARG
Patrolletter>' order by entrydate asc
On some rows that I entered yesterday, the 5th column totals just
fine, on others I entered today, I get nothing. This only seems to
be the case on One table, the other tables seem to work fine where
I am doing the same kind of query. Any ideas what might be going on
here?
Mark Weiss
http://trustthechildren.blogspot.com
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
------- End of Original Message -------
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Mark Weiss
http://trustthechildren.blogspot.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
