Display message when no records are selected

Hi everyone,

I'm using CC to display records from a table of my DB and I'd like to display a message (something like "No records found.") when no records are selected within the SQL "WHERE clause" that I set (e.g. " WHERE status = 'Draft' ").

Any idea about how to do that?

TIA

Francesco

Hi Francisco,

There are threads about this here somewhere. Both Emmanuel and I posted slightly different solutions - I think mine was in the header and his in the footer.

Bob

Thanks a lot! I've just found it as you said: it is working very well!!!