<div dir="ltr">Hello guys,<div><br></div><div style>I have the following config for nibbebill:</div><div style><br></div><div style><div> <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};" /></div>
<div> <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};" /></div>
<div><br></div></div><div style>I see this on the log, which is obviously failing:</div><div style><br></div><div style><br></div><div style> [UPDATE cards_table SET balance=balance- WHERE pin=12345;]<br></div><div style>
<br></div><div style>is ${nibble_increment} not the correct variable to use? It looks like it is empty!</div><div style><br></div><div style>Thanks!</div><div style><br></div><div style>David</div></div>