#704 SQLParam Plug In Bug

2.6.8
open
Unknown (89)
5
2012-12-29
2009-01-28
kreigv
No

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)
) A

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).
Thank you.

Discussion


Log in to post a comment.