The following code produces an error when I try to run it under
putty.exe (telent connection to mysql database). Can anyone identify
the error in the code? The server is running PHP5.

Thanks

DELIMITER ;;
/*!50003 DROP PROCEDURE IF EXISTS `aaa` */;;
/*!50003 SET SESSION
SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER" */;;
/*!50003 CREATE PROCEDURE `aaa`()
begin
declare iTest int;
set iTest = 5;
end */;;

tns wrote:

The following code produces an error when I try to run it under
putty.exe (telent connection to mysql database). Can anyone identify
the error in the code? The server is running PHP5.
>
Thanks
>
DELIMITER ;;
/*!50003 DROP PROCEDURE IF EXISTS `aaa` */;;
/*!50003 SET SESSION
SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER" */;;
/*!50003 CREATE PROCEDURE `aaa`()
begin
declare iTest int;
set iTest = 5;
end */;;
>

This isnt php code (i think you know this already) its a stored
procedure in SQL.

Armando Padilla wrote:

tns wrote:

This isnt php code (i think you know this already) its a stored
procedure in SQL.

Check that :). is there something obviously wrong with the syntax?

"tns" <cbdiets@hotmail.comwrote:

Armando Padilla wrote:

>
Check that :). is there something obviously wrong with the syntax?

You haven't told us which RDBMS you are using. In any case it's
off-topic, but as asked, the question is unanswerable.

miguel
--
Photos from 40 countries on 5 continents: http://travel.u.nu
Latest photos: Malaysia; Thailand; Singapore; Spain; Morocco
Airports of the world: http://airport.u.nu

tns wrote:

Armando Padilla wrote:
>

>
>
Check that :). is there something obviously wrong with the syntax?
>

You might try asking in a mysql newsgroup - such as comp.databases.mysql.

This newsgroup is for php questions.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================