Forums
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
"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