title: Erlang ODBC parameter query with null parameters
body: <p>Is it possible to pass null values to parameter queries?  For example</p>
  
  <pre><code>Sql = "insert into TableX values (?,?)".
  Params = [{sql_integer, [Val1]}, {sql_float, [Val2]}].
  
  % Val2 may be a float, or it may be the atom, undefined
  
  odbc:param_query(OdbcRef, Sql, Params).
  </code></pre>
  
  <p>Now, of course odbc:param_query/3 is going to complain if Val2 is undefined when trying to match to a sql_float, but my question is...  Is it possible to use a parameterized query, such as:</p>
  
  <pre><code>Sql = "insert into TableY values (?,?,?,?,?,?,?,?,?)".
  </code></pre>
  
  <p>with any null parameters?  I have a use case where I am dumping a large number of real-time data into a database by either inserting or updating.  Some of the tables I am updating have a dozen or so nullable fields, and I do not have a guarantee that all of the data will be there.</p>
  
  <p>Concatenating a SQL together for each query, checking for null values seems complex, and the wrong way to do it.</p>
  
  <p>Having a parameterized query for each permutation is simply not an option.</p>
  
  <p>Any thoughts or ideas would be fantastic!  Thank you!</p>