[ic] sql tag problem
interch
interchange-users@interchange.redhat.com
Thu Oct 4 17:49:00 2001
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]