phpMyAdmin

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
chopWood
Forum Commoner
Posts: 45
Joined: Fri Apr 30, 2010 9:28 am

phpMyAdmin

Post by chopWood »

I am using Version 3.2.4 of phpMyAdmin and have, apparently, been successful in creating a stored procedure which I called "get_stuff". Now I'm trying to figure out how to CALL it from within the SQL window.



So I tried to follow it with:

CALL practice2.get_stuff(12);

However I get the result:

#1312 - PROCEDURE practice2.get_stuff can't return a result set in the given context

any thoughts on this?
thanks,
chop
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Re: phpMyAdmin

Post by Jade »

chopWood
Forum Commoner
Posts: 45
Joined: Fri Apr 30, 2010 9:28 am

Re: phpMyAdmin

Post by chopWood »

I am using MAMP Version 3.2.4 of phpMyAdmin. Still can't get the CALL to work
chop
Doug G
Forum Contributor
Posts: 282
Joined: Sun Sep 09, 2007 6:27 pm

Re: phpMyAdmin

Post by Doug G »

If the mysql server is on your computer try using the command line mysql to test your procedure. That will eliminate large chunks of potential problem-causing software like a phpmyadmin issue or something.
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Re: phpMyAdmin

Post by Jade »

Did you check your mysql permissions to make sure you can run stored procedures for localhost and your server?
Post Reply