beer-monkey.com
|
| Posted: 03/08/2002, 7:20 AM |
|
I have a site which displays job vacancies, this website will obviously display a record from a database... what i need is that is a record no longer exists on the database that a "sorry this vacancy is no longer available" message appears in its place?
for example: http://www.primetime-education.co.uk/jobs/VacancyView.asp?vacancy_id=42 (this is fine becasue the record exists)
however if you went to: http://www.primetime-education.co.uk/jobs/VacancyView.asp?vacancy_id=1 you get a bizarre blank html template.... how could this be prevented?
|
|
|
 |
Nicole
|
| Posted: 03/11/2002, 4:19 AM |
|
Hello,
you may copy generated sql to temporary sql variable and execute it (form Open event) in order to find whether the record exists. If yes, set any flag var e.g. to 1. Create Custom Show event display table fields or custom message depending on flag value.
|
|
|
|
|
