2. PHPRunner General questions
  3. Display a message when table is empty
This topic is locked

Display a message when table is empty

 		2/3/2011 10:28:07 AM
PHPRunner General questions
G
 goffj1 author

I have a query that looks at a classrooms schedule for that days events, and displays the "list page" for all upcoming events where the "end time" of an event is > the current system time.
The signage software reloads the page every few minutes so expired events drop off and the remaining events march up the page. All works well - as events "expire" they no longer show up on the sign.
Is there a simple way check the SQL query that builds the dataset and when it returns empty, all events for that day have expired, I can do a responsewrite, or other, to dispaly a message like "ALL OF TODAYS EVENTS HAVE ENDED" rather than have the list page just go blank?
L
 		lummis 2/4/2011



I have a query that looks at a classrooms schedule for that days events, and displays the "list page" for all upcoming events where the "end time" of an event is > the current system time.
The signage software reloads the page every few minutes so expired events drop off and the remaining events march up the page. All works well - as events "expire" they no longer show up on the sign.
Is there a simple way check the SQL query that builds the dataset and when it returns empty, all events for that day have expired, I can do a responsewrite, or other, to dispaly a message like "ALL OF TODAYS EVENTS HAVE ENDED" rather than have the list page just go blank?