------=_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 [at] sRow =3D startRow;
set [at] pSize =3D pageSize;
set [at] 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 [at] kWords, [at] sRow, [at] 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--
