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
>  Select Field1, Field2, Field3 From MyTable
>  Where Field3=strVal;
> End

varchar is meant to be variable, so it MUST have a length supplied.  If you 
want the same flexibility without specifying a specific length, use TEXT 
instead.

-- 
Chris White
PHP Programmer
Interfuel

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to