Ok, this might be a silly one. Though I have no problem solving this issue by dynamically building the query, there should be a better solution due to repreparing the statement...
Within the where clause of the query that is prepared...' where foo = ? When binding an undef value when executing, this executes "where foo = NULL". In Oracle there is a difference between foo = NULL and foo is NULL. This also kind of disallows you to prepare the statement, since you must check for the undef binding value and reprepare with "is NULL". Maybe someone knows a better way of doing this, but I would envision a facility that does this for you when binding NULLs to where clause placeholders. Ilya
