[ic] sql tag problem

[interch]

This query does not return a match, but it thinks it does and returns
 Paid commissions and a null value for [sql-code].  None of the database
entries contain paid in the commission_status field.



[query sql="select sum(commission) from transactions where affiliate =
'[cgi affiliate]' and commission_status = 'paid'" interpolate
=1 type=list ml=100]

[on_match]
Paid Commissions:$
[/on_match]

[no_match]
No Commissions Paid
[/no_match]

[list]
[sql-code]
[/list]
[/query]