RE: [ic] sql tag problem

["Dan Browning" <danpb@mail.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]

Suggestions...

remove interpolate=1
add list=1

HTH,

Dan Browning <danpb@mail.com>

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