Forums

Where clause using a "greater than" function

momentis 01 Mar, 2016
I am setting up a CC connection, and I would like to pull records from a table where the field "trv_deposit" is greater than 0. The database table field is DECIMAL(10,2), and the default value is 0.00. I cannot seem to figure out how to create a WHERE clause in the connection's model in order to only display records with a deposit amount in them greater than 0.00.

Thanks!!
Rick
momentis 01 Mar, 2016
Answer
I figured it out. If anyone else needs it, here's the solution:

<?php
return array('trv.trv_deposit >' => 0);
?>


Rick
This topic is locked and no more replies can be posted.