Problem with 4.1.3 that I not had with 4.0.20

2004-08-24 Thread Martin Rytz
Good Morning Community! I have a problem with 4.1.3 that I not had with 4.0.20. Here is my table: CREATE TABLE url_cat_copy ( id int(11) NOT NULL auto_increment, url varchar(100) default NULL, domain varchar(100) default NULL, bytes bigint(20) default NULL, hits bigint(20) default

Re: Problem with 4.1.3 that I not had with 4.0.20

2004-08-24 Thread Leonardus Setiabudi
try this query SELECT bytes, bytes_priv, bytes_bus, hits, hits_priv, hits_bus, bytes - ( bytes_priv + bytes_bus ), hits - (hits_priv + hits_bus) FROM url_cat_copy WHERE (bytesround(bytes_priv+bytes_bus,0)) or (hitsround(hits_priv + hits_bus,0)) i think its got something to do with the decimal