From: Martijn Tonies (m.toniesupscene.com)
Date: Fri Dec 05 2008 - 11:34:55 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

> I'm trying to create a trigger (5.0.45) and I've read the documentation
> at mysql.com. I keep getting a syntax error, but can't figure out what
> the error is. Here's the trigger I'm trying to create:
>
> delimiter //
> create trigger jobposts_control
> before delete on jobposts for each row
> begin
> declare dummy varchar(255);
> set counted = (
> select count(ad.adsource_id)
> from adsource ad, jobposts jp
> where ad.adsource_id = jp.adsource_id
> and old.jobpost_id = jp.jobpost_id
> );
> if counted >= 1 then SET dummy = "Cannot delete this record" end if;
> end //
> delimiter ;
>
> When I run the set query without the "and old.jobpost_id" line, it runs
> correctly. So the syntax problem is elsewhere, but where?

What is the exact error message?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Free Database Workbench Lite for MySQL at www.upscene.com !

Database questions? Check the forum:
http://www.databasedevelopmentforum.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]