SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:50 AM
| ||||
| ||||
 Re: trigger 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      |
|
02-28-2008, 05:50 AM
| ||||
| ||||
| Re: trigger 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. |
Linear Mode
