Dynamic Pages - Handling No Records

mark_anderson_us · **Joined:** Fri Mar 16, 2012 12:21 pm **Posts:** 59

I am building a visitor board. At the top left it has the company logo and centered on the top it has "ACME Welcomes"

It's all working well with dynamic pages; however, on many days we have no visitors and in these cases it would display the page with just the logo and "ACME Welcomes"

Is there a way to have it not generate ANY of the dynamic pages when there are no records returned (it would just show other pages in sequence) or have something display instead of the text on the blank dynamic page

aleezy · **Joined:** Thu Mar 28, 2013 5:42 am **Posts:** 1

Nice surprise about this shorter form. Can you tell us what it is you are talking/writing about?
Has any info. about this shorter form been posted before (and i just missed it)?

mark_anderson_us · **Joined:** Fri Mar 16, 2012 12:21 pm **Posts:** 59

Not sure I understand your question, but I solved my problem

I use an excel file as an ODBC data source and a SQL query

I have one tabe with visitor names and one with images

The page has a text box for image boxes and on top of it is a picture box (also linked to ODBC source). The image box will be empty when there are visitors (Query returns no records)

My SQL Query (not real SQL below, just giving an idea: if you're interested I canpost the actual SQL) for visitors is

Select * FROM Sheet Where Date = Today

The Query for the images is essentially

Select * from ImagesSheet (the where clause returns no records if the count of visitors is > 0 and records if count of visitors is 0)

Regards

mark