I'm trying to write to an Oracle database using a form. When I click on the submit button in IE, everything works great. However, when I try to submit the same form using Netscape, I recieve a document contains no data error message. I've tried changing my cache options, etc... and have no idea what else to try. Here is my code. Any help would be appreciated!!!
<% @LANGUAGE="VBSCRIPT" %>
<!--#include Virtual=/includes/adovbs.inc -->
<!--#include Virtual=/includes/connect_asys.inc -->
<html>
<head>
<title>Advisor Feedback Form</title>
<!--#include Virtual=/includes/topnavbarASYS.inc -->
</head>
<script language="JavaScript">
<!--
function FeedbackResponse()
{
if (document.advisor_response.feedback.value != ""
{
document.advisor_response.submit();
}
else
{
document.advisor_response.feedback.focus();
return;
}
}
//-->
</SCRIPT>
<style>
a{text-decoration:none}
</style>
<body onLoad="navBarInit()">
<br>
<%
dim sql, rs
dim sqlNextKey, sqlInsert, nextKey, sqlResponse
%>
<TABLE WIDTH=615 CELLPADDING=0 CELLSPACING=0>
<tr>
<td width=15> </td>
<td width=700 align=center>
<img src=/images/headers/headadvisorfeedback.gif width=600 height=100 border=0 alt="Advisor Feedback Form">
</td>
</tr>
</table>
<table width=715 cellpadding=2 cellspacing=2>
<tr>
<td width=15 valign=top> </td>
<td width=600 align=center valign=top>
<br>
<%
If Request.Form("update" = "True" then
sqlResponse = "select * from dss.web_adv_feedback " & _
" where feedback_key = " & Request.Form("feedback"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open sqlResponse, dbConnectASYS, 3, 3
if rs.EOF then
response.redirect("/advisorfeedbackprob.html"
else
rs.Fields("reply" = Request.Form("reply"
rs.Fields("responded_by" = Request.Form("respcontact"
rs.update
rs.close
set rs=nothing
response.redirect("/test/advisor_response.asp"
'response.write("after updating form"
response.write("</td></tr></table>"
end if
Else
Select Case Request.Form("requestType"
Case "response":
sqlResponse = "select * from dss.web_adv_feedback " & _
" where feedback_key = " & Request.Form("feedback"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open sqlResponse, dbConnectASYS, 3, 3
if rs.EOF then
response.write("Invalid Feedback Key. Please use BACK error and try again!!!!"
else
response.write("<form name=advisor_response method=post action=/test/advisor_response.asp>"
response.write("<tr><td colspan=2 align=center><br><font size=5><b>Update Advisor Feedback</b></font><br><br></td></tr>"
response.write("<tr><td width=40%25 align=right>Feedback Key:</td>"
response.write("<td width=60%25 align=left><input type=text name=feedback size=5 value=" & chr(34) & rs.Fields("feedback_key" &chr(34) & "></td></tr>"
response.write("<tr><td width=40%25 align=right>Advisor Name:</td>"
response.write("<td width=60%25 align=left><input type=text name=subcontact size=40 value=" & chr(34) & rs.Fields("submitted_by" & chr(34) & "></td></tr>"
response.write("<tr><td width=40%25 align=right>Category:</td>"
Select Case rs.Fields("category_num"
Case 1:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "Enrollment " &chr(34) & "></TEXTAREA></td></tr>"
Case 2:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "Executive Desk " &chr(34) & "></TEXTAREA></td></tr>"
Case 3:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "Quality " &chr(34) & "></TEXTAREA></td></tr>"
Case 4:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "Subscriber " &chr(34) & "></TEXTAREA></td></tr>"
Case 5:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "All " &chr(34) & "></TEXTAREA></td></tr>"
End Select
response.write("<tr><td width=40%25 align=right>Question/Comment:</td>"
response.write("<td width=60%25 align=left><TEXTAREA ROWS=5 COLS=50 name=comment>" & rs.Fields("ques_com" & "</TEXTAREA></td></tr>"
response.write("<tr><td width=40%25 align=right>Response:</td>"
response.write("<td width=60%25 align=left><TEXTAREA ROWS=5 COLS=50 name=reply>" & rs.Fields("reply" & "</TEXTAREA></td></tr>"
response.write("<tr><td width=40%25 align=right>Responded by:</td>"
response.write("<td width=60%25 align=left><input type=text name=respcontact size=40 value=" & chr(34) & rs.Fields("responded_by" &chr(34) & "></td></tr>"
response.write("<tr><td colspan=2 align=center><input type=submit value=Submit> "
response.write("<input type=reset value=Reset></td></tr></table>"
response.write("<input type=hidden name=update value=True>"
End If
Case Else:
response.write("<form name=advisor_response action=advisor_response.asp method=POST>"
response.write("<tr><TD Width=40%25 ALIGN=center><font face=Verdana,Sans-Serif size=2>Enter Feedback Key:</td>"
response.write("<td width=60%25 align=left><input type=text name=feedback size=5></td></tr><br><br>"
response.write("<tr><td width=colspan=2 align=right><input type=button name=btnfeedback value=" & chr(34) & "Retrieve Feedback" & chr(34) & " onClick=" & chr(34) & "FeedbackResponse()" & chr(34) & "></p></td></tr></table>"
response.write("<input type=hidden name=requesttype value=" & chr(34) & "response" & chr(34) & ">"
response.write("<input type=hidden name=update value=False>"
End Select
Response.write("</table></form>"
end if
%>
<!--#include Virtual=/includes/footer2.inc -->
<% @LANGUAGE="VBSCRIPT" %>
<!--#include Virtual=/includes/adovbs.inc -->
<!--#include Virtual=/includes/connect_asys.inc -->
<html>
<head>
<title>Advisor Feedback Form</title>
<!--#include Virtual=/includes/topnavbarASYS.inc -->
</head>
<script language="JavaScript">
<!--
function FeedbackResponse()
{
if (document.advisor_response.feedback.value != ""
{
document.advisor_response.submit();
}
else
{
document.advisor_response.feedback.focus();
return;
}
}
//-->
</SCRIPT>
<style>
a{text-decoration:none}
</style>
<body onLoad="navBarInit()">
<br>
<%
dim sql, rs
dim sqlNextKey, sqlInsert, nextKey, sqlResponse
%>
<TABLE WIDTH=615 CELLPADDING=0 CELLSPACING=0>
<tr>
<td width=15> </td>
<td width=700 align=center>
<img src=/images/headers/headadvisorfeedback.gif width=600 height=100 border=0 alt="Advisor Feedback Form">
</td>
</tr>
</table>
<table width=715 cellpadding=2 cellspacing=2>
<tr>
<td width=15 valign=top> </td>
<td width=600 align=center valign=top>
<br>
<%
If Request.Form("update" = "True" then
sqlResponse = "select * from dss.web_adv_feedback " & _
" where feedback_key = " & Request.Form("feedback"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open sqlResponse, dbConnectASYS, 3, 3
if rs.EOF then
response.redirect("/advisorfeedbackprob.html"
else
rs.Fields("reply" = Request.Form("reply"
rs.Fields("responded_by" = Request.Form("respcontact"
rs.update
rs.close
set rs=nothing
response.redirect("/test/advisor_response.asp"
'response.write("after updating form"
response.write("</td></tr></table>"
end if
Else
Select Case Request.Form("requestType"
Case "response":
sqlResponse = "select * from dss.web_adv_feedback " & _
" where feedback_key = " & Request.Form("feedback"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open sqlResponse, dbConnectASYS, 3, 3
if rs.EOF then
response.write("Invalid Feedback Key. Please use BACK error and try again!!!!"
else
response.write("<form name=advisor_response method=post action=/test/advisor_response.asp>"
response.write("<tr><td colspan=2 align=center><br><font size=5><b>Update Advisor Feedback</b></font><br><br></td></tr>"
response.write("<tr><td width=40%25 align=right>Feedback Key:</td>"
response.write("<td width=60%25 align=left><input type=text name=feedback size=5 value=" & chr(34) & rs.Fields("feedback_key" &chr(34) & "></td></tr>"
response.write("<tr><td width=40%25 align=right>Advisor Name:</td>"
response.write("<td width=60%25 align=left><input type=text name=subcontact size=40 value=" & chr(34) & rs.Fields("submitted_by" & chr(34) & "></td></tr>"
response.write("<tr><td width=40%25 align=right>Category:</td>"
Select Case rs.Fields("category_num"
Case 1:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "Enrollment " &chr(34) & "></TEXTAREA></td></tr>"
Case 2:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "Executive Desk " &chr(34) & "></TEXTAREA></td></tr>"
Case 3:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "Quality " &chr(34) & "></TEXTAREA></td></tr>"
Case 4:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "Subscriber " &chr(34) & "></TEXTAREA></td></tr>"
Case 5:
response.write("<td width=60%25 align=left><input type = text name=category size=20 value=" & chr(34) & "All " &chr(34) & "></TEXTAREA></td></tr>"
End Select
response.write("<tr><td width=40%25 align=right>Question/Comment:</td>"
response.write("<td width=60%25 align=left><TEXTAREA ROWS=5 COLS=50 name=comment>" & rs.Fields("ques_com" & "</TEXTAREA></td></tr>"
response.write("<tr><td width=40%25 align=right>Response:</td>"
response.write("<td width=60%25 align=left><TEXTAREA ROWS=5 COLS=50 name=reply>" & rs.Fields("reply" & "</TEXTAREA></td></tr>"
response.write("<tr><td width=40%25 align=right>Responded by:</td>"
response.write("<td width=60%25 align=left><input type=text name=respcontact size=40 value=" & chr(34) & rs.Fields("responded_by" &chr(34) & "></td></tr>"
response.write("<tr><td colspan=2 align=center><input type=submit value=Submit> "
response.write("<input type=reset value=Reset></td></tr></table>"
response.write("<input type=hidden name=update value=True>"
End If
Case Else:
response.write("<form name=advisor_response action=advisor_response.asp method=POST>"
response.write("<tr><TD Width=40%25 ALIGN=center><font face=Verdana,Sans-Serif size=2>Enter Feedback Key:</td>"
response.write("<td width=60%25 align=left><input type=text name=feedback size=5></td></tr><br><br>"
response.write("<tr><td width=colspan=2 align=right><input type=button name=btnfeedback value=" & chr(34) & "Retrieve Feedback" & chr(34) & " onClick=" & chr(34) & "FeedbackResponse()" & chr(34) & "></p></td></tr></table>"
response.write("<input type=hidden name=requesttype value=" & chr(34) & "response" & chr(34) & ">"
response.write("<input type=hidden name=update value=False>"
End Select
Response.write("</table></form>"
end if
%>
<!--#include Virtual=/includes/footer2.inc -->