CodingForums.com - View Single Post

BubikolRamios · 02-28-2013, 08:30 AM

before update trigger:

Code:

set new.id_tezaver = (select IFNULL(id_tezaver,0) from tezaver t where term = new.term and l2='la' )

--> column id_tezaver can not be null

Yeah, I know it returns null, but should be sorted by ifnull ?

EDIT: I see it now, it actualy returns nothing, not null.
How to write trigger for that ?

02-28-2013, 08:30 AM	PM User \| #1
BubikolRamios Senior Coder Join Date: Dec 2005 Location: Slovenia Posts: 1,876 Thanks: 114 Thanked 76 Times in 76 Posts	trigger problem before update trigger: Code: set new.id_tezaver = (select IFNULL(id_tezaver,0) from tezaver t where term = new.term and l2='la' ) --> column id_tezaver can not be null Yeah, I know it returns null, but should be sorted by ifnull ? EDIT: I see it now, it actualy returns nothing, not null. How to write trigger for that ? __________________ Found a flower or bug and don't know what it is ? agrozoo.net galery if you don't spot search button at once, there is search form: agrozoo.net galery search Last edited by BubikolRamios; 02-28-2013 at 08:49 AM..