stored procedure not working on win 2k3

------=_Part_71431_12450648.1136694241127
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Folks,
when I try and implement this stored procedure on mysql 5.0.18 running on
win 2k3, i get a 1064 error for syntax on the the following line:
select SQL_CALC_FOUND_ROWS * from currentbidding where expired=3D'N' AND
match(itemname) against (? IN BOOLEAN MODE) limit ?,?

DELIMITER $$

DROP PROCEDURE IF EXISTS `emp`.`test4` $$
CREATE PROCEDURE `test4`(startRow int, pageSize int, keywords char(120))
BEGIN
set @sRow =3D startRow;
set @pSize =3D pageSize;
set @kWords =3D keywords;
prepare stmt from "select SQL_CALC_FOUND_ROWS * from currentbidding where
expired=3D'N' AND match(itemname) against (? IN BOOLEAN MODE) limit ?,?";
execute stmt using @kWords, @sRow, @pSize;
select found_rows();
END $$

DELIMITER ;

Table definition:


CREATE TABLE "emp"."currentbidding" (
"itemid" int(10) unsigned NOT NULL auto_increment,
"itemName" varchar(120) NOT NULL default '',
"expired" char(1) NOT NULL default 'N',
PRIMARY KEY ("itemid"),
KEY "ActiveListing" ("expired"),
FULLTEXT KEY "fulltext" ("itemName")
);

The stored procedure works without any problems on windows xp with the same
version of mysql.

I just did a backup of the database and restored it on the win2k3 box and
get the

Any help is appreciated.

Thanks,
LP

------=_Part_71431_12450648.1136694241127--