SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Sep 2007
    Posts
    202
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    This is so strange

    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

  2. #2
    SitePoint Guru
    Join Date
    Jun 2007
    Posts
    686
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The database location you are using in this example is exposed to the public world. If this is the current and real location of your database, somebody could be hacking into the file and literally deleting the contents. You should secure the database by placing it above the domain and adding a password to the connection string.

  3. #3
    SitePoint Addict
    Join Date
    Sep 2007
    Posts
    202
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Webber...

    Thanks for the information. What do you mean by placing it above the domain?

    Thanks,
    Sarb

  4. #4
    SitePoint Guru
    Join Date
    Jun 2007
    Posts
    686
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Above the domain means the database file is on the server but in a folder one level above your website. The website will be accessible for the public but the folders above it will not.

    Speak to your programmer to get you safe.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •