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)

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.