I am not sure if DBIx::Recordset has its own list so I am posting here,
please redirect me if needed.

I want to create a query that looks for IS NULL in one of the fields,
but I don't see how to do that in the docs.

The query it is creating always as a field_name = ? for the place
holder.  I just want to "append" something like 'AND field_name IS NULL'
to the query string instead of the place holder.  Is that possible?

I know this code below won't work, but that is what I want to be able to
do.

$set->Select( { ORDER => "$ORDER",
                            NUMBER => "$NUMBER",
                            Note_Body => 'IS NULL'
                    } );

In Recordset.pm the only reference to IS NULL I see is in the
%unaryoperators and the code near line 2095.

Aaron Johnson


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to