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."
===============================================