Re: Syntax Error in Stored Procedure

2007-08-13 Thread Tom Khoury
Thanks. That fixed the problem. I put all of my DECLARE statements at the beginning of the procedure. I finally got the thing to compile and it looks like this: DELIMITER $$ DROP PROCEDURE IF EXISTS `code_library`.`Search_Code_Samples` $$ CREATE [EMAIL PROTECTED] PROCEDURE `Search_Code_Sampl

RE: Syntax Error in Stored Procedure

2007-08-13 Thread Price, Randall
Tom, I think the problem might be that you have to put all the DECLARE statements at the top before the other statements. It seems like I had a similar problem with this once. Hope this helps. Randall Price Secure Enterprise Technology Initiatives Microsoft Implementation Group Virginia Tech I