We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

How to display a notice when there is nothing to display

Martin Cotterill
on
Medium Priority
289 Views
Last Modified: 2010-04-25
Hi Experts

I have created a site that uses data within an Access database and everything is working just fine.

But something that ran across my mind (I really must get out more) is what happens if there isn't any data to display? How would I inform the user that there are no records to display?

I would like to put something along the lines of "Sorry. There are no records that meet your request".

How would I do this?

Many thanks in advance.

Regards

Martin
Comment
Watch Question

Don't talk to me.
CERTIFIED EXPERT
Commented:
Hi Martin,

This is what the Show Region server behavior is used for.  Simply write whatever text you want to display if there is no data and highlight it.  Then go to the Applications Panel, Server Behaviors tab, and add Show Region -> If recordset is empty.

You should also select all other text on the page that should display if there IS data and use the Show Region -> If recordset is not empty on it.  This way, the page will hide all of the "normal" text when there is no data.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Excellent J!

Works perfectly!

Many thanks!

Regards

Martin
Jason C. LevineDon't talk to me.
CERTIFIED EXPERT

Commented:
Thanks Martin,

You should also examine the code the DW uses to create these "Show If" regions.  It's very simple and once you get the hang of it, you can use the same or similar syntax to create more complicated conditional regions.  I use this trick to show or hide areas based on certain values in the record being viewed, set CSS options based on database values, and more.  

Author

Commented:
Thanks for the tip J, I'll certainly do that.

Martin
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.