SqlWhereClause

SqlWhereClause — Create a WHERE clause using the values in dict.

SqlWhereClause DictValue

Return Value

A string of the form Key1 = Value1 AND Key2 = Value2 AND ... where keys and values come from the dict.

Arguments

DictValue

Contains column name / value pairs to create a where clause.

More Info

Note that this command will only combine elements using AND.

Note that for the dicts, you (currently) must put quotes around any values that will go into text columns or receive an error. We may add support in a future release for automatically detecting the column type and quoting values as necessary.

For information regarding exceptions / errors, see here.

% SqlWhereClause {desc 'first' notes '1-2-3'}
desc = 'first' AND notes = '1-2-3'