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)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
