trigger problem - CodingForums.com

SMS enable your application via Clickatell’s fast, simple and reliable API's, built to integrate with any system. Click here to learn more.

Flash Website Builder- Trendy Site Builder is a Flash Site Building tool that helps users build stunning websites.

Check Out Custom Custom Logo Design by LogoBee. Website Design and Free Logo Templates available.

		CodingForums.com > :: Server side development > MySQL
trigger problem

Before you post, read our: Rules & Posting Guidelines

Enjoy an ad free experience by logging in. Not a member yet? Register.

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..

Bookmarks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT +1. The time now is 03:06 AM.