Bob Schroeck Wrote:Ooh. That just might be it. I'll have to give that a try when I get home tonight. Thanks!
And no, that's not it. I am growing increasingly confused at what is going on. I can run "select * from mybb_threads" just fine, but if I put it inside a "BEGIN/END" block it suddenly throws a syntax error. And with or without "BEGIN/END", I still get a syntax error on trying to declare a variable. ... Wait. I just tried something completely stupid, and of course it works. Even though DECLARE and its uses are thoroughly documented, it appears the only way I can actually declare a variable is to do what's flagged as the wrong answer on that Stack Over flow page: "SET @mybb_tid = 0;" works. How dumb is that? <sigh> Time to rewrite my script.-- Bob
---------
Then the horns kicked in...
...and my shoes began to squeak.