I just spent quite a while hunting out a bug that turned out to be a mis-spelled session variable defaulting to NULL.
Ultimately what I want is, if I used a session veriable without defining it before hand with a SET, MySQL would return an error. Such problem doesn't exist in T-SQL, for example, because you have to define the variables with the DECLARE clause before you use them. In addition, some dynamically-typed scripting langauges use a directive to enforce this policy, such as OPTION EXPLICIT in VBScript. Is there an equivalent option or directive in MySQL? Thanks, Homam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]