PDA

View Full Version : List<FilterConfig> to SQL statement?



$p00ky
29 Feb 2012, 6:35 PM
Hi,

Is there any built-in method or available class to generate a "WHERE ..." SQL statement from a list of FilterConfig, or do we have to do it by ourselves?

For example for a FilterConfig of a numeric field, return "myField < 4".
For a string field "myField LIKE %something%".

I'm sure everybody needs such feature so it should be available but couldn't find it...
Any help?

Best,

$p00ky