From: Peter Brawley
Date: November 30 2005 5:10am
Subject: Re: SQLquery: delimiter // - #1064 error
List-Archive: http://lists.mysql.com/mysql/192319
Message-Id: <438D343B.4070503@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 >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

-----

vancouverhg@stripped 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:David.Logan@stripped] 
>Sent: Tuesday, November 29, 2005 2:59 PM
>To: Dave Kennedy; mysql@stripped
>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:vancouverhg@stripped] 
>Sent: Wednesday, 30 November 2005 9:25 AM
>To: mysql@stripped
>Subject: SQLquery: delimiter // - #1064 error 
>
>Windows XP
>phpMyAdmin 2.7.0-rc1
>MySQL 5.0.16-nt running on localhost as root@localhost
>
>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