Format anomoly when empty table is last item on page

[lozdown]

If I have a table component as the last (or only) item on the page and the associated table query returns no rows SQLPage does not display the "empty_description" field.

Example code

select 'table' as component, true as small,'No cash deposited for period' as empty_description;

select null as Total;

[lovasoa]

Hi! if your table has a row (even with a single column and a value of NULL), then it is not considered empty. You should add a where condition to the query that computes the total.

select 'table' as component; 

select name, value, total from products; 
select sum(total) as total from products having count(*)>0;

[lozdown]

Thanks - obvious in retrospect!