Re: Trying to Create a Trigger

[Lola J. Lee Beno]

Andy Shellam wrote:
> I'm guessing it's the first semi-colon in your IF statement.  Does 
> this work...?
>
>   if @counted >= 1 then SET dummy = 'Cannot delete this record' end if;
>
> Just a guess!
>
> Andy.
>

That's not it, unfortunately. 

ERROR: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right
syntax to use near 'if @counted >= 1 then SET dummy = 'Cannot
delete this record' end if' at line 1

Query = if @counted
 >= 1 then SET dummy = 'Cannot delete this record' end if


-- 
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
"In rivers, the water that you touch is the last of what has passed
and the first of that which comes; so with present time." - Leonardo da Vinci (1452-1519)