NULL parameter for ODBC param_query

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

NULL parameter for ODBC param_query

Ryan Huffman
Is it possible to use null values in a parameterized query?

example: odbc:param_query("exec User_Read ?", [{sql_integer, Param}]).  %
Param is either an integer or null

The odbc driver returns the 'null' atom when selecting rows, but I haven't
found a value that allows me to specify a null parameter ('null', 'NULL',
<<"null">>, etc...)