Re: Need Help Writing a Trigger

2005-12-28 Thread Jesse
OTECTED]> To: "Jesse" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Wednesday, December 28, 2005 1:48 PM Subject: Re: Need Help Writing a Trigger Jesse, >BTW, is there a way to change this function so that it does away with the >"today" variable, and use

Re: Need Help Writing a Trigger

2005-12-28 Thread Peter Brawley
that table instead? Thanks, Jesse - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Jesse" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Wednesday, December 28, 2005 10:20 AM Subject: Re: Need Help Writing a Trigger Jesse, >T

Re: Need Help Writing a Trigger

2005-12-28 Thread Jesse
le instead? Thanks, Jesse - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Jesse" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Wednesday, December 28, 2005 10:20 AM Subject: Re: Need Help Writing a Trigger Jesse, >Ther

Re: Need Help Writing a Trigger

2005-12-28 Thread Peter Brawley
- Original Message - From: "Jesse" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Tuesday, December 27, 2005 4:34 PM Subject: Need Help Writing a Trigger I'm trying to write a trigger that will update the age of a camper when ever a record is updated or inserted.

Re: Need Help Writing a Trigger

2005-12-28 Thread Jesse
MAIL PROTECTED]> To: "MySQL List" Sent: Tuesday, December 27, 2005 4:34 PM Subject: Need Help Writing a Trigger I'm trying to write a trigger that will update the age of a camper when ever a record is updated or inserted. I have a table named Campers which contains basic inf

Re: Need Help Writing a Trigger

2005-12-27 Thread John Meyer
On Tuesday 27 December 2005 2:34 pm, Jesse wrote: > I'm trying to write a trigger that will update the age of a camper when > ever a record is updated or inserted. I have a table named Campers which > contains basic information about the camper as well as their birthday. I > have another table na

Need Help Writing a Trigger

2005-12-27 Thread Jesse
I'm trying to write a trigger that will update the age of a camper when ever a record is updated or inserted. I have a table named Campers which contains basic information about the camper as well as their birthday. I have another table named Config which holds various settings, including the