Specific mysql Trigger question

mysql ver 5.0.26 standard Can a trigger call a procedure that returns a result set? I am trying to get around this error msg. ERROR 1415 (0A000): Not allowed to return a result set from a trigger Thanks -winn Below is a more concise description of my issue and logic pattern when a record is

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

Re: trigger

missppelled contact_id) NEW.contact_id and total_amount = contact_max_amount; - Original Message - From: Winn Johnston [EMAIL PROTECTED] 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

Re: How can I detect if MySql is already installed?

-standard-5.0.18-0.sles9 MySQL-client-standard-5.0.18-0.sles9 Also you are going to have to figure out if you use php if so you must check to see if it is installed as well, and compiled with mysql support. hope this helps -winn johnston

Help with mysql triggers

| | 3 | 118 | | 2 | 126 | ++-+ Thanks very much in advance Winn Johnston The fish are biting. Get more visitors on your site using Yahoo! Search

RE: mysql + LVS

there is no need to load-balance your reads and writes. Thanks, Jimmy Guerrero MySQL, Inc -Original Message- From: Winn Johnston [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 3:26 PM To: mysql@lists.mysql.com Subject: mysql + LVS How stable has it become to run

RE: mysql + LVS highjacked (mysql + NFS ramfs)

--- Winn Johnston [EMAIL PROTECTED] wrote: --- Jimmy Guerrero [EMAIL PROTECTED] wrote: Hello, Just to make sure we separate the two... mysql cluster that preforms reads on all the slaves, and writes only on the master. The above can be used to describe a typical use

mysql + LVS

on the subject. I know this differs from the idea that you can have a mysql cluster that preforms reads on all the slaves, and writes only on the master. thanks winn johnston __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection

developing an interface

a similar feel on the new interface. I am leaning heavily to php, since it would make the Internet port easier, but am not adversed to changing my mind. Thank You very much for your replies. Winn Johnston __ Do you Yahoo!? Yahoo! Mail

interface developing

a similar feel on the new interface. I am leaning heavily to php, since it would make the Internet port easier, but am not adversed to changing my mind. Thank You very much for your replies. Winn Johnston __ Do you Yahoo!? Yahoo! Mail - Easier

Re: developing an interface

--- [EMAIL PROTECTED] wrote: Winn Johnston [EMAIL PROTECTED] wrote on 02/04/2005 10:30:54 AM: I have taken on a job replacing an old AS400 RPM database with four thin clients. They really like the feel of the thin client interface, no point and click, no graphics, just green text

Re: developing an interface

lynx i like it :) thanks duncan, u the man winn johnston -- Duncan Hill [EMAIL PROTECTED] wrote: On Friday 04 February 2005 16:03, Winn Johnston might have typed: My users have expressed a distinct dislike for point and click methods. They would rather use the keyboard