title: MySQL Procedure with IN date fails
body: <p>First time poster really appreciate any assistance.  </p>
  
  <p>I am completely stuck on an issue with MySQL stored procedures and completely green to them.</p>
  
  <p>Here is the procedure as it is currently written, MySQL accepts it without any issue so unless there is a syntax error, the procedure is written correctly.</p>
  
  <p>However when I call the procedure 
  <code>call test (2011-04-01, 2011-04-07);</code>
   no results are returned, yet the select statement works just fine.</p>
  
  <pre><code>CREATE PROCEDURE `NewProc`(IN `@StartDate` date,IN `@EndDate` date)
  
  BEGIN
  
  SELECT aux1, aux2, aux3, aux4, date, id, type,
      CASE
          WHEN results = 'pass' THEN '1'
          WHEN results = 'fail' THEN '0'
          ELSE '-1'
      END AS CertStatus,
      CASE
          WHEN results = 'pass' THEN '1'
          WHEN results = 'fail' THEN '0'
          ELSE '-1'
      END AS TestStatus,
      CASE
          WHEN results = 'pass' THEN '1'
          WHEN results = 'fail' THEN '0'
          ELSE '-1'
      END AS TestStatus,
      CASE
          WHEN results = 'pass' THEN '1'
          WHEN results = 'fail' THEN '0'
          ELSE '-1'
      END AS TestStatus
  from completed
  WHERE date &gt;= '@StartDate' and date &lt;= '@EndDate';
  END;
  </code></pre>