Get ready for BLACK FRIDAY shopping starting in

Forums

ASP

This topic is locked

show message if records are empty

Posted 04 Mar 2004 09:46:16
1
has voted
04 Mar 2004 09:46:16 sander kerstens posted:
hi there,

i have a question:

i have a page with jobopenings the come from the database table jobs
i have applied the repeat region if
more than 1 jobs are available....

now i need to show the message no
jobs at this moment when there are
no records...

thanks for youre help

greetzzz Sander

Replies

Replied 04 Mar 2004 13:36:16
04 Mar 2004 13:36:16 Dave Thomas replied:
create a message for users to see if there is no openings.

"Sorry there are no jobs available in this section. blah blah blah."

I usually stick this message in a table cell, much easier to control and format that way i find.

then go into server behaviours, and >> SHOW IF RECORDSET IS EMPTY

which will output some code like

If rs.Example is EOF then
write my message.



Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

Reply to this topic