Re: Stored procedure parameters problem

2006-12-05 Thread Ed Reed
Hi Paul, I've spent the past two days trying to reproduce my problem and I think I may have brought this on myself. I've had been trying to create a procedure with the Query Browser GUI and was unable to do so. So I tried to create them with MySQL-Front and MySQL Control Center and somehow I was

Re: Stored procedure parameters problem

2006-12-02 Thread Paul DuBois
At 11:34 AM -0800 12/1/06, Chris White wrote: On Friday 01 December 2006 11:22, Ed Reed wrote: I have a problem/question I'd like to find someone else to verify/answer for me. I'm using MySQL 5.1.09 running on Netware. I've created a stored procedure that has one parameter, Create Procedu

Re: Stored procedure parameters problem

2006-12-01 Thread Ed Reed
Got it. Thanks >>> Chris White <[EMAIL PROTECTED]> 12/1/06 11:34 AM >>> On Friday 01 December 2006 11:22, Ed Reed wrote: > I have a problem/question I'd like to find someone else to verify/answer > for me. > > I'm using MySQL 5.1.09 running on Netware. I've created a stored > procedure that has

Re: Stored procedure parameters problem

2006-12-01 Thread Chris White
On Friday 01 December 2006 11:22, Ed Reed wrote: > I have a problem/question I'd like to find someone else to verify/answer > for me. > > I'm using MySQL 5.1.09 running on Netware. I've created a stored > procedure that has one parameter, > > Create Procedure MyTest(strVal VarChar) > Begin > Selec

Stored procedure parameters problem

2006-12-01 Thread Ed Reed
I have a problem/question I'd like to find someone else to verify/answer for me. I'm using MySQL 5.1.09 running on Netware. I've created a stored procedure that has one parameter, Create Procedure MyTest(strVal VarChar) Begin Select Field1, Field2, Field3 From MyTable Where Field3=strVal; En