>Error
>SQL query:
>call p0(
>)
>MySQL said:
>#1312 - PROCEDURE tr.p0 can't return a result set in the given context
To permit calling of stored procedures, the CLIENT_MULTI_STATEMENTS flag
must be set (4th param to mysql_connect() or mysql_pconnect()). Looks
like the phpMyAdmin working group hasn't implemented that yet. I posted
a question about this on a phpMyAdmin forum, but didn't get a response.
PB
-----
[EMAIL PROTECTED] wrote:
HI David,
The following error is generated calling the previously defined stored
procedure p0() in phpmyadmin:
Error
SQL query:
call p0(
)
MySQL said:
#1312 - PROCEDURE tr.p0 can't return a result set in the given context
Any suggestions would be greatly appreciated
-----Original Message-----
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 2:59 PM
To: Dave Kennedy; mysql@lists.mysql.com
Subject: RE: SQLquery: delimiter // - #1064 error
Hi Dave,
The DELIMITER statement is a command to the mysql client not an SQL
statement. This is why phpAdmin is objecting. Here are a listing of the
mysql client commands
http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: Dave Kennedy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 30 November 2005 9:25 AM
To: mysql@lists.mysql.com
Subject: SQLquery: delimiter // - #1064 error
Windows XP
phpMyAdmin 2.7.0-rc1
MySQL 5.0.16-nt running on localhost as [EMAIL PROTECTED]
The DELIMITER statement works in the command line, but not in phpmyadmin
(see error below)
mysql> DELIMITER //
mysql> use mysql //
Database changed
mysql>
PHPmyadmin =======================
DELIMITER //
Error
There seems to be an error in your SQL query. The MySQL server error
output
below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 11
STR: //
SQL: delimiter //
SQL query:
delimiter //
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near
'delimiter //' at line 1
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.10/186 - Release Date: 11/29/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
