Wrox Programmer Forums
|
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 11th, 2006, 08:32 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default MySQL 5.0

Hello everyone!

I am having quite a frustrating time with MySQL 5.0, specifically with stored procedures.

What I have is a stored procedure that calls another stored procedure and am trying to use a query to populat the parameters for the stored procedure such as:

CALL storedprocedure(SELECT [columnlist] from [table] Where [Clause])

MySql doesn't like this, however. Can anyone tell me if this is even possible?

"The one language all programmers understand is profanity."
__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================





Similar Threads
Thread Thread Starter Forum Replies Last Post
Why not MySQL ??? mysticav BOOK: Professional PHP 5 ISBN: 978-0-7645-7282-1 1 August 18th, 2006 04:32 PM
mysql help benzspida MySQL 1 April 6th, 2006 04:31 AM
mysql g.tamilselvan MySQL 1 February 22nd, 2006 10:45 AM
MYSQL hkurtulus BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 1 November 23rd, 2005 05:59 PM
MySQL 4.0 or 4.1 allang MySQL 1 January 10th, 2004 10:12 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.