Errors?

[tns]

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="STRIC T_TRANS_TABLES, NO_AUTO_CREATE_ USER"*/;;
/*!50003 CREATE PROCEDURE `aaa`()
begin
declare iTest int;
set iTest = 5;
end */;;

[Armando Padilla]

Re: Errors?

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="STRIC T_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.

[tns]

Re: Errors?


Armando Padilla wrote:

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="STRIC T_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.

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

[Miguel Cruz]

Re: Errors?

"tns" <cbdiets@hotmai l.comwrote:

Armando Padilla wrote:

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="STRIC T_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.

>
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

[Jerry Stuckle]

Re: Errors?

tns wrote:

Armando Padilla wrote:
>

>>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="ST RICT_TRANS_TABL ES,NO_AUTO_CREA TE_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.

>
>
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@attgl obal.net
=============== ===