SEO

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'

Anyone has a solution? Thanks in advance

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

On 24 Apr, 10:24, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> On Thu, 24 Apr 2008 10:20:43 +0200, Manuele Piastra <manu...@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

adding SET NAMES utf8; on top of the create trigger command
it works....thank you so much

Manuele Piastra wrote:
> On 24 Apr, 10:24, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>> On Thu, 24 Apr 2008 10:20:43 +0200, Manuele Piastra <manu...@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?
>
> adding SET NAMES utf8; on top of the create trigger command
> it works....

Is that so? Seems strange to me as there are no 'special' characters,
all ascii,,,,

> thank you so much

Well, glad to have been of help apparantly?

--
Rik Wasmus