[Freeswitch-users] nibblebill custom_sql_save

[Muhammad Shahzad]

Did you set nibble_increment variable? e.g.

<variable name="nibble_increment" value="30" />

Here is its details,

http://wiki.freeswitch.org/wiki/Mod_nibblebill#Nibble_Method_.28Default.29

Thank you.


On Wed, Feb 20, 2013 at 2:10 PM, David Villasmil <
david.villasmil.work at gmail.com> wrote:

> 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
>>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>


-- 
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)
Cell: +49 176 99 83 10 85
MSN: shari_786pk at hotmail.com
Email: shaheryarkh at googlemail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130220/e4b51d27/attachment.html