[Freeswitch-users] nibblebill custom_sql_save

[David Villasmil]

Anyone about this?

Thanks


On Mon, Feb 18, 2013 at 2:07 PM, David Villasmil <
david.villasmil.work at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130220/ccff942e/attachment-0001.html