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
