Re: [Freeswitch-users] nibblebill custom_sql_save

Anyone about this? Thanks On Mon, Feb 18, 2013 at 2:07 PM, David Villasmil < david.villasmil.work@gmail.com> wrote:

Hello guys,

I have the following config for nibbebill:

<param name="custom_sql_lookup" value="SELECT ${card_db_column_cash} AS nibble_balance FROM ${card_db_table} WHERE ${card_db_column_account}=${nibble_account};" /> <param name="custom_sql_save" value="UPDATE ${card_db_table} SET ${card_db_column_cash}=${card_db_column_cash}-${nibble_increment} WHERE ${card_db_column_account}=${nibble_account};" />

I see this on the log, which is obviously failing:

[UPDATE cards_table SET balance=balance- WHERE pin=12345;]

is ${nibble_increment} not the correct variable to use? It looks like it is empty!

Thanks!

David