Syntax Error in Stored Procedure

2007-08-13 Thread Tom Khoury
Below is a new stored procedure that I am trying to make for building a SQL with the supplied parameters. 1:DELIMITER $$ 2:CREATE PROCEDURE `Search_Code_Samples`( 3:IN search_words VARCHAR(300) 4: , IN multi_word_condition VARCHAR(3) 5: , IN language_id INT 6: , IN

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