I keep getting this error

ERROR 1415 (0A000): Not allowed to return a result set
from a trigger

--- Rolando Edwards <redwards@swmx.com> wrote:

> insert into max_donations (donation_id, contact_id)
> select donation_id, contact_id
> from donation_test where conatct_id = (You
> missppelled contact_id)
> NEW.contact_id and total_amount =
> contact_max_amount;
>
> ----- Original Message -----
> From: "Winn Johnston" <winn_johnston@yahoo.com>
> To: mysql@lists.mysql.com
> Sent: Wednesday, February 21, 2007 11:26:42 AM
> (GMT-0500) Auto-Detected
> Subject: trigger
>
> Any way to get this to work inside an after update
> trigger?
>
> insert into max_donations (donation_id, contact_id)
> select donation_id, contact_id
> from donation_test where conatct_id =
> NEW.contact_id and total_amount =
> contact_max_amount;
>
>
> thanks
> winn
>
>
>
>
__________________________________________________ __________________________________
> Have a burning question?
> Go to www.Answers.yahoo.com and get answers from
> real people who know.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=redwards@swmx.com
>
>
>




__________________________________________________ __________________________________
Have a burning question?
Go to www.Answers.yahoo.com and get answers from real people who know.