[Freeswitch-users] nibblebill custom_sql_save

[David Villasmil]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130218/d68750fe/attachment.html