Thank you very much Christian!
On Mon, Jul 28, 2008 at 3:39 PM, Poitras Christian <
[EMAIL PROTECTED]> wrote:
> On MySQL, you can use <=> instead of = for null safe comparison.
>
> resultClass="long">
> SELECT ColumnUID
> WHERE
> Column1 <=> #property1#
> AND Column2 = #property2#
>
>
On MySQL, you can use <=> instead of = for null safe comparison.
SELECT ColumnUID
WHERE
Column1 <=> #property1#
AND Column2 = #property2#
You can also test null values with tag.
SELECT ColumnUID
WHERE
Column1 IS NULL
Column1 = #property1#
AND Column2 = #
I am not getting the expected results when executing a select statement
containing null values.
I have the following example:
SELECT ColumnUID
WHERE
Column1 = #property1#
AND Column2 = #property2#
In java:
class RecordItem {
private String property1;
private String property2;
...
hi Sundar,
Thanks you for your help. By this way , i have been able to find my problem.
It was a mistake from my side in the tool BPM.
In fact, like you said, my params were not intialize correctly and he
couldn't find a value for them.
I correct it and now it is worked.
Samuel
--
View this
