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