Skip to Content
0
Former Member
Jul 15, 2010 at 09:09 AM

MII 12.1 TimeUnavailable insted of nulldate

113 Views

Hi,

I'm currently facing a problem in MII 12.1.

I have a SQL query template, that executes a sql statement on an ORACLE database like

select field from table

The field is of datatype date and can be null.

I'm calling this sql query in a transaction and iterate over the result rows with a repater.

In the repeated code I wan't to do different things depending on if the field is null or not.

In MII 12.0 I used the conditional action and added the following as input:

Repeater_0.Output{/Row/field}==nulldate

But in MII 12.1 this condition always returns false. The only way I found to get this working was to use the following condition

Repeater_0.Output{/Row/field}=="TimeUnavailable"

It seems to me that it is not possible to get null values from date fields in a transaction?!

If I do the same for a char field and compare with nullstring, it does work.

Does anyone know this behaviour and has a solution?

Regards Timo