What's wrong with this custom column?

[RobertRock]

Hi,

I am trying to create a column to count the number of occurences that a player bet on the river and see the showdown. Because there is already a similar column for raising and seeing the showdown, I copied it and changed it slightly to fit my need. Unfortunately I get the following error when saving "The statement is not valid SQL".

Here is the original cnt_r_raise_wtsd:
sum(if[holdem_hand_player_statistics.cnt_r_raise > 0 AND holdem_hand_player_statistics.flg_showdown, 1, 0])

Here is the revised one that gives the error:
sum(if[holdem_hand_player_statistics.cnt_r_bet > 0 AND holdem_hand_player_statistics.flg_showdown, 1, 0])

Thanks for any help.

[kraada]

There isn't a cnt_r_bet field in the database; it's being created as a column.

What you want is:

Code: Select all

sum(if[holdem_hand_player_statistics.flg_r_bet AND holdem_hand_player_statistics.flg_showdown, 1, 0])