cast and numeric conversion

2005-08-16 Thread Philippe Poelvoorde
Hi, I've got two columns, one is 'integer' (and store negative value), the other one 'tinyint unsigned' (only 1 stored in it), when I multiply these columns, quantity with negative value does not show up. (I expect -50*10 to give : -500, but the field stay blank.) I've look a bit at the

Re: cast and numeric conversion

2005-08-16 Thread Scott Noyes
I've got two columns, one is 'integer' (and store negative value), the other one 'tinyint unsigned' (only 1 stored in it), when I multiply these columns, quantity with negative value does not show up. (I expect -50*10 to give : -500, but the field stay blank.) I've look a bit at the

Re: cast and numeric conversion

2005-08-16 Thread Philippe Poelvoorde
Scott Noyes wrote: I've got two columns, one is 'integer' (and store negative value), the other one 'tinyint unsigned' (only 1 stored in it), when I multiply these columns, quantity with negative value does not show up. (I expect -50*10 to give : -500, but the field stay blank.) I've look a bit