Where clause using a "greater than" function

Question

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 · Accepted Answer

I figured it out.  If anyone else needs it, here's the solution:' => 0); ?>Rick

Forums

Where clause using a "greater than" function