[triggers] Forum Topics

i want to be abale to update the filed 'activated' to 0 when the 'expireDate' is before today. can you show me how to do it with a trigger? (i want to do this after the user insert the row)

Hi All, Is it possible to bind an array or a Vector with a event listener? For an example if we add an element to the Vector or remove from the Vector, can I use an event listener to track the changes? Thanks a lot in advance. Cheers..!!

I have got a grid[Grid1] that build its data when a button[search] is clicked, I managed to Ajaxify it by placing it in an UpdatePanel. Before Ajaxifying Grid 1, the grid used to populate another grid[Grid2] and some other controls[Text and Labels] when a row in Grid 1 was clicked …

Hi I there a way to make a trigger completely independent from the calling table so that even if the trigger is made invalid, inserts can still be done to the table that calls the trigger? I created the following trigger: [CODE] CREATE OR REPLACE TRIGGER LOCAL.SYNC_TRIGGER AFTER INSERT ON …

any one know how to create trigger for update one column if column have value = 'cityname' then raise error or print error if value is null the don't do any thing

First the table [CODE]create table customer( no int NOT NULL auto_increment, cust_id varchar(15) NOT NULL, cust_name varchar(50), cust_address text(150), cust_phone int, cust_email varchar(30), PRIMARY KEY(no));[/CODE] Then the trigger [CODE]DELIMITER | CREATE TRIGGER trig BEFORE insert on customer FOR EACH ROW BEGIN set new.cust_id=concat(new.cust_name,new.no); END; DELIMITER |[/CODE] Then the insert query …

This trigger is making me nuts! I've written about a dozen triggers before but nothing where I have ever pulled data from another table. What this is supposed to do is make sure that any inserted rows have a latitude/longitude (lat/lon) value. The users table has the lat/lon and these …

Hi, I had two columns in Master table (Employee) id,name In My Audit table(Employee_Audit) i have to insert record with id, name, date What's the problem is,.. I want to get the old data before the field gets updated,.. Ex: Employee id name 1 Ram i had changed to 2 …