[ic] sql tag problem

[interch <interch@web3.valley-internet.com>]

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]


_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users