fyi...No category for SQLParam plugin.
I really like SQLParam plugin but it doesn't work with Where clause IN statements and BETWEEN CAST date statements. I only seem to be able to get it to work with straight WHERE = statements. Is anyone aware of these problems with SqlParam? Some examples are below. Thank you.
WHERE a.bsn_un_ky = b.bsn_orgn_id
AND b.id IN (:PARAM1) - does not work with IN
AND a.a_number IN (:PARAM2)
AND a.b_number IN (:PARAM3)
AND a.c_number IN (:PARAM4)
AND a.number IN(:PARAM5)
WHERE AL1.week_end_dt BETWEEN CAST(:FromDate AS DATE)
AND CAST(:ToDate AS DATE) - does not work with CAST
Also, Sql Param doesn't let you have a colon anywhere in the code, for example, in the time stamp of a date, or in commented out code (there is another bug in the tracker regarding the latter).