Hi all

I have a website that includes a form that the HR person types in current job openings for public viewing. The asp form allows her to type in the new entry and it appears on the job openings page. This was created by a programmer, not myself. I am not a programmer. My abilities end at cut and pasting.

We recently redesigned the website, but the programming for this page remained the same.

The problem is, she posts the info on the jobopenings.asp page. And it works fine. The new postings automatically appear on the website in the jobopenings.asp page. Just like the programming is suppose to work. The problem is, that after a couple days, all the info she enters disappears and reverts to the page that says "no openings".

We cannot figure out why this is happening. The client had implemented some new software a bit ago and it was causing havoc with the site initially, but they got it all straightened out. Their person does not think it is occurring on their end. I have asked my programmer and he says he cannot figure out what could be happening either. Everything works fine, but the information disappears after a couple days. There doesn't seem to be a pattern to it. The job files are in a subfolder called "oaknoll" but I don't think that should be an issue here...

Any ideas what could be happening?

The website address is:

http://www.oaknoll.com

The link is under Employment/job openings at the bottom of the navigation menu or http://www.oaknoll.com/oaknoll/jobopenings.asp.

The form that the new positions are typed into is http://www.oaknoll.com/oaknoll/jobs_edit.asp

Any thoughts? I will put the code for the two files below if that helps:

jobs_edit.asp code:

Code:

<?xml version="1.0" encoding="iso-8859-1"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
<!-- #include virtual="/oaknoll/include/DSN.asp" -->

<head>
<title>Oaknoll - An Adult Retirement Community</title>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="Keywords"
 content="oaknoll, iowa city, retirement, elderly, iowa, LifeCare, retirement community, nursing home, apartment, independent living, resident, geriatric, aging, community, retire, retired, elder,  health care, assisted living, nursing care">
<meta name="Description"
 content="Oaknoll is an adult retirement community in Iowa City, Iowa.">
<meta name="robots" content="index,follow">

<!-- code for employment update form begins here -->


<%

Response.Expires = 0

function brtagFixer(strIn)
    
    dim temp
    
	temp = replace(strIn, "<br>", vbcrlf)

    brtagFixer = temp
      
  end function

dim cn, rs, sql

'Open and verify connection to DB
set cn = server.CreateObject("ADODB.Connection")
cn.Open cnString("\data", "oaknoll.mdb")

sql = "SELECT * FROM jobopenings"
set rs = cn.Execute(sql)

%>


<!-- code for employment update form ends here -->





<!-- include Cycle plugin SLIDESHOW -->

<!-- include jQuery library -->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
<!-- include Cycle plugin -->
<script type="text/javascript" src="http://cloud.github.com/downloads/malsup/cycle/jquery.cycle.all.latest.js"></script>
<script type="text/javascript">
$(document).ready(function() {
    $('.slideshow').cycle({
		fx: 'fade' // choose your transition type, ex: fade, scrollUp, shuffle, etc...
	    	
			});


   
$('#s3').cycle({ 
    fx:    'fade', 
	
    speed:  8500,
	
	cleartype: 1,
cleartypeNoBg: false,
height: 'auto',
containerResize: 0,

timeout: 2000,

sync: 0,

fadeOut:'slow', 



nowrap: 0,
randomizeEffects: 0,
pause: 2
	


});
	
	
	


});
</script>


 <!--Vertical Slider Navigation javascript - code on external page-->    
    
<script type="text/javascript" src="js/external_navigation_menu_javascript.js"></script>

 <!--endofVerticalSliderNavigationjavascript-->  


		
 
  
<!--tocorrecttheunsightlyFlashofUnstyledContenthttp://www.bluerobot.com/web/css/fouc.asp-->
	<script type="text/javascript"> </script>
	

	

<!--[if lt IE 7]>
<link rel="stylesheet" type="text/css" href="ie6.css" />
<![endif]-->


<link rel="stylesheet" href="../css/oaknoll_newsite.css" type="text/css" />
<link rel="stylesheet" href="../css/nav_css.css" type="text/css" />

</head>

<body>

<div id="container">

 <!--#include virtual="includes/header_asp.asp"-->
		
       
       
        
		<div id="main">
         
         
        <div id="box1">
       <div class="slideshow">
		<img src="../images/sls/nurse_station.jpg" width="400" height="300" alt="Nurses Station" class="first" />
		</div> <!--end-of-slideshow-->
        </div><!--end-box-1-->
        
        <div id="box2">                
   	  <div class="buttonbox"><img src="../images/4_special_buttons.jpg" alt="internet buttons" width="181" height="300" border="0" usemap="#Map" />
        <map name="Map" id="Map">
          <area shape="rect" coords="14,8,178,70" href="http://www.touchtown.tv/tv/tv/webshow/tv1.jsp?tag=OAKNOLL_WEB" target="_blank" alt="Link to Oaknoll Announcements" border="none" />
          <area shape="rect" coords="14,86,177,145" href="http://www.facebook.com/Oaknoll?ref=sgm" target="_blank" alt="Link to Oaknoll's Facebook Page" border="none"/>
          <area shape="rect" coords="16,161,172,213" href="http://oaknoll.blogspot.com/" target="_blank" alt="Link to the Oaknoll Blog" />
          <area shape="rect" coords="18,233,175,297" href="hawkeye.asp" alt="Link to Golden Hawkeye Birthday Club" />
        </map>
   	  </div><!--BUTTONBOX--> 
        </div><!--end-box-2-->
        
  
   
   <h1 style="clear:left;">Update Job Opportunites...</h1>
  
  
   <form action="jobsupdate.asp" method="post">
            <p><b><i><font size="+2">Current Job Openings </font></i></b></p>
           
		    <p><b><u><font size="2">Opportunities in Nursing</font></u></b></p>
            <blockquote> 
              <textarea name="nursing" cols="50" rows="8"><%= brtagfixer(cstr(rs("nursing"))) %></textarea>
            </blockquote>
           
           
            <p><b><u><font size="2">Opportunities in Social Work</font></u></b> 
            </p>
            <p> </p>
            <blockquote> 
              <textarea name="recreation" cols="50" rows="8"><%= brtagfixer(cstr(rs("social"))) %></textarea>
            </blockquote>
           
           
            <p> <b><u><font size="2">Opportunities in Dining Services</font></u></b> 
            </p>
            <p> </p>
            <blockquote> 
              <textarea name="food" cols="50" rows="8"><%= brtagfixer(cstr(rs("food"))) %></textarea>
            </blockquote>
            
            
            <p><b><u><font size="2">Opportunities in Recreation</font></u></b> 
            </p>
            <p> </p>
            <blockquote> 
              <textarea name="recreation" cols="50" rows="8"><%= brtagfixer(cstr(rs("recreation"))) %></textarea>
            </blockquote>
          
		  
           <p><b><u><font size="2">Opportunities in Wellness</font></u></b> 
            </p>
            <p> </p>
            <blockquote> 
              <textarea name="recreation" cols="50" rows="8"><%= brtagfixer(cstr(rs("wellness"))) %></textarea>
            </blockquote>
          
          
          <p><b><u><font size="2">Opportunities in Housekeeping and Laundry</font></u></b></p>
            <p> </p>
            <blockquote> 
              <textarea name="housekeeping" cols="50" rows="8"><%= brtagfixer(cstr(rs("housekeeping"))) %></textarea>
            </blockquote>
          
          
           <p><b><u><font size="2">Opportunities in Building and Grounds</font></u></b></p>
            <p> </p>
            <blockquote> 
              <textarea name="building" cols="50" rows="8"><%= brtagfixer(cstr(rs("building"))) %></textarea>
            </blockquote>		  	  		 
		           
           			
			
			 <p><b><u><font size="2">Opportunities in Administration</font></u></b></p>
            <p> </p>
            <blockquote> 
              <textarea name="admin" cols="50" rows="8"><%= brtagfixer(cstr(rs("admin"))) %></textarea>
            </blockquote>
			
            <p align="center"> 
              <input type="submit" name="Submit" value="Submit Changes" />
              &nbsp;&nbsp; 
              <input type="reset" name="reset" value="Discard Changes" />
            </p>
          </form>
  
  
        
</div>
        
        
     
      

   <!--#include virtual="includes/menu_asp.asp"-->

 
        
	 <!--#include virtual="includes/footer_asp.asp"-->
  
 
  </div><!--end-of-main-->
</div><!--end-of-container-->
</body>
</html>
jobopenings.asp code:

Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!-- #include virtual="/oaknoll/include/DSN.asp" -->

<%

Response.Expires = 0

function formatJobs (strIn)
	dim temp
	If strIn = "" or isnull (strIn) or isempty (strIn) Then
		temp = "- no current openings</p>"
	Else
		temp = "</p><p><blockquote>" & strIn & "</blockquote>"
	End If
	formatJobs = temp
end function

dim cn, rs, sql

'Open and verify connection to DB
set cn = server.CreateObject("ADODB.Connection")
cn.Open cnString("/data", "oaknoll.mdb")

sql = "SELECT * FROM jobopenings"
set rs = cn.Execute(sql)

%>


<html lang="en">
<head>
<title>Oaknoll - An Adult Retirement Community</title>
<meta name="Keywords"
 content="oaknoll, iowa city, retirement, elderly, iowa, LifeCare, retirement community, nursing home, apartment, independent living, resident, geriatric, aging, community, retire, retired, elder,  health care">
<meta name="Description"
 content="Oaknoll is an adult retirement community in Iowa City, Iowa.">
<meta name="Author" content="Heather Clark for Gazette Communications">
<meta name="robots" content="index,follow">


<!-- include Cycle plugin -->

<!-- include jQuery library -->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
<!-- include Cycle plugin -->
<script type="text/javascript" src="http://cloud.github.com/downloads/malsup/cycle/jquery.cycle.all.latest.js"></script>
<script type="text/javascript">
$(document).ready(function() {
    $('.slideshow').cycle({
		fx: 'fade' // choose your transition type, ex: fade, scrollUp, shuffle, etc...
	    	
			});


$('#s3').cycle({ 
    fx:    'fade', 
    speed:  5500,
	cleartype: 1,
cleartypeNoBg: false,
height: 'auto',
containerResize: 0,

timeout: 8000,

sync: 0,

fadeOut:'slow', 



nowrap: 0,
randomizeEffects: 0,
pause: 0
	
	
 });

});
</script>

		

<!--Vertical Slider Navigation javascript - code on external page-->    
    
<script type="text/javascript" src="js/external_navigation_menu_javascript.js"></script>

 <!--endofVerticalSliderNavigationjavascript-->  

  
  
<!--tocorrecttheunsightlyFlashofUnstyledContenthttp://www.bluerobot.com/web/css/fouc.asp-->
	<script type="text/javascript"> </script>
	

	

<!--[if lt IE 7]>
<link rel="stylesheet" type="text/css" href="ie6.css" />
<![endif]-->


<link rel="stylesheet" href="http://www.oaknoll.com/css/oaknoll_newsite.css" type="text/css" />
<link rel="stylesheet" href="http://www.oaknoll.com/css/nav_css.css" type="text/css" />
<link rel="stylesheet" href="http://www.oaknoll.com/css/employment.css" type="text/css" />



</head>
<body>

<div id="container">

 <!--#include virtual="includes/header_asp.asp"-->
		
       
       
        
		<div id="main">
        
          <div id="equal_op"> <img src="../images/equal_opp2.jpg" width="198" height="23" alt="Equal Opportunity Employer" /></div>
         
        <div id="box1">
       <div class="slideshow">
		<img src="../images/sls/jobopenings_page.jpg" width="400" height="300" alt="Nurses Station" class="first" />
		
	   </div> <!--end-of-slideshow-->
        </div><!--end-box-1-->
        
       
          <div id="box2">                
   	  <div class="buttonbox"><img src="../images/4_buttons_silvergames.jpg" alt="internet buttons" width="181" height="300" border="0" usemap="#Map" />
        <map name="Map" id="Map">
          <area shape="rect" coords="14,8,178,70" href="http://www.touchtown.tv/tv/tv/webshow/tv1.jsp?tag=OAKNOLL_WEB" target="_blank" alt="Link to Oaknoll Announcements" border="none" />
          <area shape="rect" coords="14,86,177,145" href="http://www.facebook.com/Oaknoll?ref=sgm" target="_blank" alt="Link to Oaknoll's Facebook Page" border="none"/>
          <area shape="rect" coords="15,161,171,213" href="http://oaknoll.blogspot.com/" target="_blank" alt="Link to the Oaknoll Blog" />
          <area shape="rect" coords="17,232,174,296" href="http://www.oaknoll.com/silver_games.asp" alt="Link to The Silver Games" />
        </map>
   	  </div><!--BUTTONBOX--> 
        </div><!--end-box-2-->
  




  <h1 style="clear:left;">Current Job Openings...</h1>
          <br />
          <p><b><u>
          Opportunities in Nursing</u> </b><%= formatJobs(cstr(rs("nursing"))) %> </p>
        
        <p> <b><u>Opportunities in Social Work</u></b><%= formatJobs(cstr(rs("social"))) %> </p>
        
          <p> <b><u>Opportunities in Dining Services</u></b><%= formatJobs(cstr(rs("food"))) %> </p>
          
          <p><b><u>Opportunities in Recreation</u></b><%= formatJobs(cstr(rs("recreation"))) %> </p>
                    
           <p><b><u>Opportunities in Wellness</u></b><%= formatJobs(cstr(rs("wellness"))) %> </p>
          
         <p><b><u>Opportunities in Housekeeping and Laundry</u></b><%= formatJobs(cstr(rs("housekeeping"))) %> </p>
         
          <p><b><u>Opportunities in Building and Grounds</u></b><%= formatJobs(cstr(rs("building"))) %> </p>
          
         <p><b><u>Opportunities in Administration</u></b><%= formatJobs(cstr(rs("admin"))) %> </p>
		  
		  <p> <b><i>To Apply:</i></b> <br />
            <br />
            <b><i> Click 
            <a href="../pdf/Application_2012_for_website.pdf" target="_blank">here</a> for 
            application.</i></b> </p>
		  <p align="left">            Print the application and mail the completed form to: </p>
          
         
        
  <p>Oaknoll Retirement Residence<br />
                  Attn: Human Resources<br />
                  1 Oaknoll Court<br />
                  Iowa City, Iowa 52246</p>
  
  
  <p>or fax your application to: <br />
                (319) 466-3023<br />
                Attn: Human Resources</p>
  <p>&nbsp;</p>
  
  
  
  </div>
        
        
     <!--#include virtual="includes/menu_asp.asp"-->

 
        
	 <!--#include virtual="includes/footer_asp.asp"-->     
      

  
  </div><!--end-of-main-->
</div><!--end-of-container-->
  
</div>
</body>
</html>
Thanks,
Sarb