Differences between Valentina 1 and 2

Carsten Friehe rblists at online.de
Thu Nov 9 18:24:53 CST 2006


Hi Ruslan!

>Ivan have check your db, and he say:
>
>  Hey! But look on this queries:
>
>     SELECT stgelesen, if (stgelesen, 1, 0)
>    SELECT anzahlkommentare, if (anzahlkommentare = 3, 1, 0)
>
>In second case you, Carsten have anzahlkommentare = 3
>
>This is a KEY :)

Yes I tested a long to see if other datatypes work, it works with Varchar also.

>You need type
>
> SELECT stgelesen, if (stgelesen = true, 1, 0)
> from daten
>
>And everything start to work

Did you tested it? In my case I still only get only Zeros no single One.

Best Regards!
Carsten


More information about the Valentina mailing list