SitePoint Sponsor

User Tag List

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

    Blank page returned in ASP


    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:

    '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" "">
    <html xmlns="">
    <title>City &amp; Guilds</title>
    <link href="css/styles.css" type="text/css" rel="stylesheet"/>
    <div id="container" >
    <img src="img/header.jpg"/>
    <div id="navigation">
        	<!--<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>-->
    <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 id="news">
    <p>News items will appear here.</p>
    <p>26/10/2011 - User testing <br />15/11/2011 - Expected launch date</p>
    <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>
    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 class="type" style="background-color:#f0ebeb; color:#000; width:200px; font-size:11px;">Advice, Guidance, Counselling and Mediation
      <!--<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';'white'" onmouseout="style.backgroundColor='#ffF';'black'">
        <td>Waiting to be judged</td>
    <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 id="help">
    <!--<div style="margin:0 auto; width:298px; text-align:center; padding-top:20px;">-->
    <P>Training guide to follow
    <!--<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>
    	' Clean Up
    	Set rsJudge2 = Nothing
    	Set cnnJudge2 = Nothing
    	Set rsJudge = Nothing
    	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
    1 Post(s)
    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


Posting Permissions

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