Quantcast

NULL parameter for ODBC param_query

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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...)

Thanks!

Ryan
Loading...