On Thu, 24 Apr 2008 10:20:43 +0200, Manuele Piastra <manupia@gmail.com>
wrote:

> I'm trying to create a trigger on a mysql 5 database. Here follows the
> script:
>
> CREATE TRIGGER awbparposinsert AFTER INSERT ON awbparzialipos
> FOR EACH ROW BEGIN
> INSERT INTO tabdogins(awbparzialeId, house, colli, peso, data,
> posmag, origId, origtipo) values( new.awbparzialeId, new.house,
> new.colli, new.peso, CURDATE(), new.codPosMagazzino, new.id, 'P');
> INSERT INTO tabdoggia(awbparzialeId, house, colli, peso, data,
> posmag) values(new.awbparzialeId, new.house, new.colli, new.peso,
> CURDATE(), new.codPosMagazzino);
> END;
>
> I get this error message:
>
> Unknown column 'new.awbparzialeId' in 'field list'

What columns does the table awbparzialipos have?
--
Rik Wasmus