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