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
