SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2009
    Posts
    73
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Blank page returned in ASP

    Hi

    I am developing a system locally which works fine. Locally i am using IIS 7.5.7600.16385.

    When I upload the files to my remote server which is using IIS 7.0.6000.16386 the asp pages dont run the script and the output is just a blank white screen with no error messages!

    The same page i go to locally runs the asp script.

    I am using to access databases that are linked together.

    Here is the script for the page:

    Code:
    <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
    <%
    
    'Dim cnnJudge
    'Dim rsJudge
    'Dim strSQL
    
    	strSQL2 = "SELECT ID FROM Users WHERE Username = '"&Session("MM_Username")&"';"
    
    	Set cnnJudge2 = Server.CreateObject("ADODB.Connection")
    	cnnJudge2.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_private/pp.mdb"))
    
    	Set rsJudge2 = cnnJudge2.Execute(strSQL2)
    	
    	Session("test") = rsJudge2("ID")	
    	
    	
    	
    	strSQL = "SELECT [tbl-nominations].[nominee-first], [tbl-nominations].[nominee-last], [tbl-nominee-type].[nominee-type], [tbl-qualifications].[qualification-title] FROM [tbl-industry-sector] INNER JOIN ([tbl-qualifications] INNER JOIN ([tbl-nominee-type] INNER JOIN [tbl-nominations] ON [tbl-nominee-type].[type-id] = [tbl-nominations].[type-id]) ON [tbl-qualifications].[qualification-id] = [tbl-nominations].[qualification-id]) ON [tbl-industry-sector].[industry-id] = [tbl-qualifications].[industry-id]  WHERE [tbl-nominations].[JUDGEID] = " & Session("test") & ";"
    
    	Set cnnJudge = Server.CreateObject("ADODB.Connection")
    	cnnJudge.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_private/pp.mdb"))
    
    	Set rsJudge = cnnJudge.Execute(strSQL)
    
    %>
    <!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">
    <head>
    <title>City &amp; Guilds</title>
    <link href="css/styles.css" type="text/css" rel="stylesheet"/>
    </head>
    <body>
    <div id="container" >
    
    <img src="img/header.jpg"/>
    
    <div id="navigation">
    	<ul>
        	<!--<li style="float:left; padding-left:7px;"><a href="#">home&nbsp;|</a></li>-->
            <li style="float:right"><a style="margin:0; padding-right:7px;" href="<%= MM_Logout %>">Logout</a></li>
            <!--<li style="float:left;"><a href="#">back&nbsp;|</a></li>
            <li style="float:left;"><a href="#">next&nbsp;|</a></li>
            <li style="float:right;"><a href="#">save &amp; continue&nbsp;|</a></li>-->
        </ul>
    </div>
    
    
    <div id="text">
    <h1>Judging home page</h1>
    <p>Welcome to the judging home page. On this page you can view our latest award news, review and score nominations and keep track of your work. </p>
    </div>
    
    <div id="news">
    <h1>News</h1>
    <p>News items will appear here.</p>
    <p>26/10/2011 - User testing <br />15/11/2011 - Expected launch date</p>
    </div>
    
    
    
    
    
    
    
    
    
    
    
    
    
    <div id="data">
    <!--<div class="candidate" style="color:#cc0000; text-align:left; font-weight:bold;">NAME</div>
    <div class="type" style="color:#cc0000; text-align:left; font-weight:bold;width:133px;">INDUSTRY</div>
    <div class="result" style="color:#cc0000; text-align:left; font-weight:bold;">TYPE</div>
    <div class="result" style="color:#cc0000; text-align:left; font-weight:bold;">OUTCOME</div>-->
    
    
    <table width="700" border="0" cellspacing="0" cellpadding="5" style="font-size:13px">
      <tr style="color:#cc0000; font-weight:bold">
        <td width="59">NAME</td>
        <td width="310">INDUSTRY</td>
        <td width="142">TYPE</td>
        <td width="102">OUTCOME</td>
        <td width="75">SCORE</td>
      </tr>
      
    
    
    <%
    Do While Not rsJudge.EOF
    %>
    
      <!--<div class="candidate" style="background-color:#f0ebeb; color:#000;"><a href="judge.2.1.asp?id=111111111111111111111111"><%=rsJudge("nominee-first")%>&nbsp;<%=rsJudge("nominee-last")%></a>
      </div>
    
      <div class="type" style="background-color:#f0ebeb; color:#000; width:200px; font-size:11px;">Advice, Guidance, Counselling and Mediation
      </div>
      
      <!--<div class="status" style="background-color:#f0ebeb; color:#000;">ss</div>
      
      <div class="result" style="background-color:#f0ebeb; color:#000;">Chief/Lead Verifier</div>
      
      <div class="type" style="background-color:#f0ebeb; color:#000;">Waiting to be judged</div>-->
      
      <a href="judge.2.1.asp?id=111111111111111111111111"><tr onmouseover="style.backgroundColor='#cc0000'; this.style.color='white'" onmouseout="style.backgroundColor='#ffF'; this.style.color='black'">
        <td><%=rsJudge("nominee-first")%>&nbsp;<%=rsJudge("nominee-last")%></td>
        <td><%=rsJudge("qualification-title")%></td>
        <td><%=rsJudge("nominee-type")%></td>
        <td>Waiting to be judged</td>
        <td>10</td>
      </tr></a>
    
    <%
      rsJudge.MoveNext
    Loop
    %>
    </table>
    </div>
    
    
    
    <div id="reference">
    <h1>Reference documents</h1>
    <p><a href="/docs/Guidelines for judges.doc" target="_blank">Full judging guidelines 2011 (Word document, 147KB)</a></p>
    <p><a href="/docs/Guidance notesV1.pdf" target="_blank">Guidance notes 2011 (PDF document, 226KB)</a></p>
    </div>
    
    <div id="help">
    <h1>Help</h1>
    <!--<div style="margin:0 auto; width:298px; text-align:center; padding-top:20px;">-->
    <P>Training guide to follow
    </div>
    
    <!--<div id="nav">
    	<div id="back"><a href="<%= MM_Logout %>">Logout</a></div>
        <div id="next"><a href="judge.2.1.asp">Next</a></div>
    </div>-->
    
    </div>
    </body>
    </html>
    <%
    	' Clean Up
    	rsJudge2.Close
    	Set rsJudge2 = Nothing
    	cnnJudge2.Close
    	Set cnnJudge2 = Nothing
    	
    	rsJudge.Close
    	Set rsJudge = Nothing
    	cnnJudge.Close
    	Set cnnJudge = Nothing
    %>
    Can anyone indicate where I have gone wrong please? Many thanks for your help!

  2. #2
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    356
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If your code is providing invalid html, maybe viewing the page source in the browser will provide a clue.
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon


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
  •