Getting Multiple records from one table

[jacek.wagner]

ELIMITER $$;
DROP TRIGGER `psm`.`UpdateProductMainProductStatesInventory`$$
create trigger `UpdateProductMainProductStatesInventory` AFTER UPDATE on `ProductSeller`
for each row BEGIN
DECLARE ProductUID int;
DECLARE N_stateCount INT default 20;
DECLARE ListPricesum int default 155;

SELECT COUNT(*),sum(ListPrice) INTO N_stateCount, ListPricesum FROM ProductSeller WHERE ProductUID = new.ProductUID;
SELECT COUNT(*),sum(ListPrice) INTO N_stateCount, ListPricesum FROM ProductSeller;

From those two select statements the first one always returns 0 count and 0 sum
The second, without the WHERE statement returns counts for all records in ProductSeller table.
How to make working the one with the WHERE statement
Note: there are no errors when the trigger is running

Jacek



Edited 3 time(s). Last edit at 07/07/2006 02:48PM by jacek.wagner.