Simple stored procedure error

DELIMITER //

DROP PROCEDURE IF EXISTS `ips`.`fetchlocationsfiltered` //
CREATE PROCEDURE `fetchlocationsfiltered`(
_locationname VARCHAR(50),
_locationstate VARCHAR(3),
_locationpostcode VARCHAR(4)
)
IF (_locationpostcode='') THEN
SELECT locationname
FROM locations
WHERE locationname=_locationname
AND locationstate=_locationstate
END IF

DELIMITER ;


This procedure continually causes error 1064 whereas the following, same as
above but without the IF statement, works perfectly:

DELIMITER //

DROP PROCEDURE IF EXISTS `ips`.`fetchlocationsfiltered` //
CREATE PROCEDURE `fetchlocationsfiltered`(
_locationname VARCHAR(50),
_locationstate VARCHAR(3),
_locationpostcode VARCHAR(4)
)
SELECT locationname
FROM locations
WHERE locationname=_locationname
AND locationstate=_locationstate //

DELIMITER ;


I have tried delimiters after the SQL statement and after the END IF however
none solve the problem.

I have read posts where some people experience error 1064 where other don't
with the same code...

I am using MySQL 5 on windows and am using the query browser software.

Thanks in advance...

Struggle with this for hours then post the question and 2 mins later
solved...

I was mixing up my delimeters... the correct procedure is:

DELIMITER //

DROP PROCEDURE IF EXISTS `ips`.`fetchlocationsfiltered` //
CREATE PROCEDURE `fetchlocationsfiltered`(
_locationname VARCHAR(50),
_locationstate VARCHAR(3),
_locationpostcode VARCHAR(4)
)
IF (_locationpostcode='') THEN
SELECT locationname
FROM locations
WHERE locationname=_locationname
AND locationstate=_locationstate;
END IF;
//
DELIMITER ;

Thanks anyway...

"McHenry" <mchenry@mchenry.com> wrote in message
news:4456d848$0$16926$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> DELIMITER //
>
> DROP PROCEDURE IF EXISTS `ips`.`fetchlocationsfiltered` //
> CREATE PROCEDURE `fetchlocationsfiltered`(
> _locationname VARCHAR(50),
> _locationstate VARCHAR(3),
> _locationpostcode VARCHAR(4)
> )
> IF (_locationpostcode='') THEN
> SELECT locationname
> FROM locations
> WHERE locationname=_locationname
> AND locationstate=_locationstate
> END IF
>
> DELIMITER ;
>
>
> This procedure continually causes error 1064 whereas the following, same
> as above but without the IF statement, works perfectly:
>
> DELIMITER //
>
> DROP PROCEDURE IF EXISTS `ips`.`fetchlocationsfiltered` //
> CREATE PROCEDURE `fetchlocationsfiltered`(
> _locationname VARCHAR(50),
> _locationstate VARCHAR(3),
> _locationpostcode VARCHAR(4)
> )
> SELECT locationname
> FROM locations
> WHERE locationname=_locationname
> AND locationstate=_locationstate //
>
> DELIMITER ;
>
>
> I have tried delimiters after the SQL statement and after the END IF
> however none solve the problem.
>
> I have read posts where some people experience error 1064 where other
> don't with the same code...
>
> I am using MySQL 5 on windows and am using the query browser software.
>
> Thanks in advance...
>