title: ASP (not .NET): sending null as parameter to stored procedure in query string?
body: <p>I have the following code on an ASP page:</p>
  
  <pre><code>&lt;%
      QueryToJSON(conn, "execute WebGetEmployeesPlanned'"
      +Request.QueryString("customercode")+"', 
      '"+Request.QueryString("lang")+"', 
      '"+Request.QueryString("date")+"'").flush
  %&gt;
  </code></pre>
  
  <p>There is no other code on this page except some includes, as I call this page with ajax from another page, using $.getJSON()</p>
  
  <p>The problem is that I don't know how I can send NULL as one of the parameters to the SP.</p>
  
  <p>Sometimes Request.QueryString("customercode") will be empty. I need to know how I can put that in the code above to make the SP see this parameter as NULL.</p>
  
  <p>I have access to the SP code so I can change something on that side to convert an empty string to null.</p>
  
  <p>Thanks in advance.</p>