Re: Trying to Create a Trigger

[David Giragosian]

On 12/5/08, Lola J. Lee Beno <lola@stripped> wrote:
>
> 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?


I'm no expert, but 'old' is a table, I'm guessing, and it isn't referenced
in the 'from' clause of the query.

could it be that simple...?

David