Errors?

#1 August 8th, 2006, 04:05 AM

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 */;;

#2 August 8th, 2006, 08:35 AM

tns wrote:

Quote:

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.

#3 August 8th, 2006, 01:35 PM

Armando Padilla wrote:

Quote:

tns wrote:

Quote:

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.

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

#4 August 8th, 2006, 04:55 PM

"tns" <cbdiets@hotmail.comwrote:

Quote:

Armando Padilla wrote:

Quote:

tns wrote:

Quote:

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.

>
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

#5 August 9th, 2006, 12:35 AM

tns wrote:

Quote:

Armando Padilla wrote:
>

Quote:

>>tns wrote:
>>

Quote:

>>>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_US ER"*/;;
>>>/*!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@attglobal.net
==================

Errors?

re: Errors?

re: Errors?

re: Errors?

re: Errors?

/bytes/development

/bytes/it

/bytes/about