[ic] sql tag problem
Dan Browning
interchange-users@interchange.redhat.com
Thu Oct 4 18:04:02 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]
Suggestions...
remove interpolate=1
add list=1
HTH,
Dan Browning <danpb@mail.com>