Forums

This topic is locked

Insert record only working on localhost

Posted 28 Jul 2006 15:53:37
1
has voted
28 Jul 2006 15:53:37 Pauline Bane posted:
I have a simple form on a page to insert a record into an MS access database.

This works fine on localhost but not on the remote server.

The permissions for both the mdb file and the folder in which it is located appear fine on the remote server with IUSR User set to both read and write.

All appears fine on other pages using this database and the table into which I want to insert the record.

I get no error message. The page to which the Insert Record behaviour is supposed to re-direct doesn't appear and the record is not inserted - it simply reloads the page with the insert form with the form blank. The pages are within a frameset with an htm extension.

I have tried to paste the page code in here but it seems incomplete in the preview window.

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/oldsectonians.asp" -->
<%
' *** Edit Operations: declare variables

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")
If (Request.QueryString <> "" Then
MM_editAction = MM_editAction & "?" & Request.QueryString
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%>
<%
' *** Insert Record: set variables

If (CStr(Request("MM_insert") = "form1" Then

MM_editConnection = MM_oldsectonians_STRING
MM_editTable = "Memories"
MM_editRedirectUrl = "memoriesindex.asp"
MM_fieldsStr = "author|value|years|value|memories|value|namenow|value"
MM_columnsStr = "author|',none,''|years|',none,''|memories|',none,''|namenow|',none,''"

' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, "|"
MM_columns = Split(MM_columnsStr, "|"

' set the form values
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
Next

' append the query string to the redirect URL
If (MM_editRedirectUrl <> "" And Request.QueryString <> "" Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "" Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If

End If
%>
<%
' *** Insert Record: construct a sql insert statement and execute it

Dim MM_tableValues
Dim MM_dbValues

If (CStr(Request("MM_insert") <> "" Then

' create the sql insert statement
MM_tableValues = ""
MM_dbValues = ""
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_formVal = MM_fields(MM_i+1)
MM_typeArray = Split(MM_columns(MM_i+1),","
MM_delim = MM_typeArray(0)
If (MM_delim = "none" Then MM_delim = ""
MM_altVal = MM_typeArray(1)
If (MM_altVal = "none" Then MM_altVal = ""
MM_emptyVal = MM_typeArray(2)
If (MM_emptyVal = "none" Then MM_emptyVal = ""
If (MM_formVal = "" Then
MM_formVal = MM_emptyVal
Else
If (MM_altVal <> "" Then
MM_formVal = MM_altVal
ElseIf (MM_delim = "'" Then ' escape quotes
MM_formVal = "'" & Replace(MM_formVal,"'","''" & "'"
Else
MM_formVal = MM_delim + MM_formVal + MM_delim
End If
End If
If (MM_i <> LBound(MM_fields)) Then
MM_tableValues = MM_tableValues & ","
MM_dbValues = MM_dbValues & ","
End If
MM_tableValues = MM_tableValues & MM_columns(MM_i)
MM_dbValues = MM_dbValues & MM_formVal
Next
MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & " values (" & MM_dbValues & ""

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> "" Then
Response.Redirect(MM_editRedirectUrl)
End If
End If

End If
%>
<%
' *** Insert Record: set variables

If (CStr(Request("MM_insert") = "memoryadd" Then

MM_editConnection = "oldsectonians;"
MM_editTable = "Memories"
MM_editRedirectUrl = "memoriesindex.asp"
MM_fieldsStr = "hidden|value|author|value|years|value|memories|value"
MM_columnsStr = "hidden|none,none,NULL|author|',none,''|years|',none,''|memories|',none,''"

' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, "|"
MM_columns = Split(MM_columnsStr, "|"

' set the form values
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
Next

' append the query string to the redirect URL
If (MM_editRedirectUrl <> "" And Request.QueryString <> "" Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "" Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If

End If
%>
<html>
<head>

<title>Old Sectonians - ex pupils and staff of the South East Essex County Technical High School..</title>
<meta name="description"
content="William Torbitt School Reunion Follow-up Website">
<meta name="keywords"
content="William Torbitt School,Ilford,Essex,school,reunion,William Torbitt,pupils,staff,former pupils,memories,messages,school photographsfriends,friends reunited,">
<link rel="stylesheet" type="text/css" href="text.css">


<style type="text/css">
<!-- A{text-decoration: none;} -->
</style>
<style fprolloverstyle>A:hover {text-decoration: underline; font-weight: bold}
</style>

</head>

<body bgcolor="#FFFFFF" link="#000066" vlink="#000066" topmargin="0" leftmargin="0">
<table border="0" cellpadding="0" cellspacing="0" width="100%"
style="border-collapse: collapse; font-family:Verdana,Arial,Helvetica,San Serif"
bordercolor="#111111">
<tr>
<td> <table
width="100%" border="0" cellpadding="5" cellspacing="0" bordercolor="#111111" bgcolor="#CCCCCC" id="AutoNumber5"
style="border-collapse: collapse">
<tr>
<td width="100%"><font color="#000099"><b> <a name="top">Add a memory</a></b></font></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%">
<p class="text" align="center"> </p>


<form method="POST" action="<%=MM_editAction%>" name="form1">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Author:</td>
<td> <input type="text" name="author" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Years:</td>
<td> <input type="text" name="years" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Memories:</td>
<td> <input type="text" name="memories" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Namenow:</td>
<td> <input type="text" name="namenow" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td> <input type="submit" value="Insert Record"> </td>
</tr>
</table>
<input type="hidden" name="ID" value="" size="32">
<input type="hidden" name="dateadded" value="" size="32">
<input type="hidden" name="showonpage" value="" size="32">
<input type="hidden" name="MM_insert" value="form1">
</form>
<p> </p>
<p> </p>
<p class="text" align="center"><b><font
face="Verdana,Arial,Helvetica,San Serif" size="3"><a
target="_self" href="memoriesindex.asp">Go back to Memories</a></font></b></p>
<p class="text" align="center"> </p>

<p> </p>

<p> </p>
 
<p> </td>
</tr>
</table>
<p><br>
 </td>
</tr>
</table>
<p> </p>
</body>
</html>


Replies

Replied 20 Sep 2007 15:43:24
20 Sep 2007 15:43:24 Doug Mouncey replied:
I am having exactly the same problem as this so it would be really appreciated if anyone knows what the problem is.
Replied 20 Sep 2007 16:35:19
20 Sep 2007 16:35:19 Pauline Bane replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I am having exactly the same problem as this so it would be really appreciated if anyone knows what the problem is.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 20 Sep 2007 16:37:43
20 Sep 2007 16:37:43 Pauline Bane replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I am having exactly the same problem as this so it would be really appreciated if anyone knows what the problem is.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

It was a long time ago and I can't remember exactly what I did to make it work but it's OK now. All I can do is paste the code of the working page here and hope it helps.

&lt;%@LANGUAGE="VBSCRIPT"%&gt;
&lt;!--#include file="Connections/oldsectonians.asp" --&gt;
&lt;%
' *** Edit Operations: declare variables

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")
If (Request.QueryString &lt;&gt; "" Then
MM_editAction = MM_editAction & "?" & Request.QueryString
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%&gt;
&lt;%
' *** Insert Record: set variables

If (CStr(Request("MM_insert") = "memoryadd" Then

MM_editConnection = MM_oldsectonians_STRING
MM_editTable = "memories"
MM_editRedirectUrl = "memoriesindex.asp"
MM_fieldsStr = "author|value|years|value|memories|value"
MM_columnsStr = "author|',none,''|years|',none,''|memories|',none,''"

' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, "|"
MM_columns = Split(MM_columnsStr, "|"

' set the form values
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
Next

' append the query string to the redirect URL
If (MM_editRedirectUrl &lt;&gt; "" And Request.QueryString &lt;&gt; "" Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString &lt;&gt; "" Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If

End If
%&gt;
&lt;%
' *** Insert Record: construct a sql insert statement and execute it

Dim MM_tableValues
Dim MM_dbValues

If (CStr(Request("MM_insert") &lt;&gt; "" Then

' create the sql insert statement
MM_tableValues = ""
MM_dbValues = ""
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_formVal = MM_fields(MM_i+1)
MM_typeArray = Split(MM_columns(MM_i+1),","
MM_delim = MM_typeArray(0)
If (MM_delim = "none" Then MM_delim = ""
MM_altVal = MM_typeArray(1)
If (MM_altVal = "none" Then MM_altVal = ""
MM_emptyVal = MM_typeArray(2)
If (MM_emptyVal = "none" Then MM_emptyVal = ""
If (MM_formVal = "" Then
MM_formVal = MM_emptyVal
Else
If (MM_altVal &lt;&gt; "" Then
MM_formVal = MM_altVal
ElseIf (MM_delim = "'" Then ' escape quotes
MM_formVal = "'" & Replace(MM_formVal,"'","''" & "'"
Else
MM_formVal = MM_delim + MM_formVal + MM_delim
End If
End If
If (MM_i &lt;&gt; LBound(MM_fields)) Then
MM_tableValues = MM_tableValues & ","
MM_dbValues = MM_dbValues & ","
End If
MM_tableValues = MM_tableValues & MM_columns(MM_i)
MM_dbValues = MM_dbValues & MM_formVal
Next
MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & " values (" & MM_dbValues & ""

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl &lt;&gt; "" Then
Response.Redirect(MM_editRedirectUrl)
End If
End If

End If
%&gt;
&lt;html&gt;
&lt;head&gt;

&lt;title&gt;Old Sectonians - ex-pupils and staff of the South East Essex County Technical High School&lt;/title&gt;
&lt;meta name="keywords" content="sectonian, south east essex, SEECTHS, reunion, pupil, ex pupil, staff, ex staff, old boys, old girls, essex, dagenham, barking, "&gt;
&lt;meta name="description" content="Old Sectonians - website for ex-pupils and staff of the South East Essex County Technical High School (SEECTHS)"&gt;
&lt;link rel="stylesheet" type="text/css" href="text.css"&gt;



&lt;style fprolloverstyle&gt;A:hover {text-decoration: underline; font-weight: bold}
&lt;/style&gt;
&lt;script language="JavaScript"&gt;

&lt;!-- This script and many more are available free online at --&gt;
&lt;!-- The JavaScript Source!! javascript.internet.com --&gt;

&lt;!-- Begin
function varitext(text){
text=document
print(text)
}
// End --&gt;
&lt;/script&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"&gt;&lt;/head&gt;

&lt;body bgcolor="#FFFFFF" link="#000066" vlink="#000066" topmargin="0" leftmargin="0"
style="font-family: Verdana,Arial,Helvetica,'San Serif'"&gt;
&lt;table width="770" border="0" cellpadding="0" cellspacing="0"&gt;
&lt;tr&gt;
&lt;td colspan="2"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="29"&gt;
&lt;tr&gt;
&lt;td width="100%" height="29" align="left"&gt; &lt;table border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%"&gt;
&lt;tr bgcolor="#000099"&gt;
&lt;td&gt; &lt;img border="0" src="images/oldsectonians.gif" width="217" height="18"&gt;&lt;/td&gt;
&lt;td align="right"&gt; &lt;img border="0" src="images/ex.gif" width="399" height="29"&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td width="120" valign="top" bgcolor="#000099"&gt;
&lt;!--#include file="menu.asp" --&gt;
&lt;/td&gt;
&lt;td class="rhline"&gt; &lt;table border="0" cellpadding="5" cellspacing="0"
style="border-collapse: collapse" bordercolor="#111111"
width="100%" id="AutoNumber5" bgcolor="#CCCCCC"&gt;
&lt;tr&gt;
&lt;td width="100%"&gt;&lt;b&gt; &lt;span class="10text"&gt;&lt;font color="#000066" size="3"&gt;&lt;b&gt;Add
a new memory&lt;/b&gt;&lt;/font&gt;&lt;/span&gt;&lt;/b&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;table border="0" cellpadding="0" cellspacing="0" width="650"
style="border-collapse: collapse; font-family:Verdana,Arial,Helvetica,San Serif"
bordercolor="#111111"&gt;
&lt;tr&gt;
&lt;td&gt;
&lt;table border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse" bordercolor="#111111" width="100%"&gt;
&lt;tr&gt;
&lt;td width="100%"&gt; &lt;form ACTION="&lt;%=MM_editAction%&gt;" METHOD="POST" name="memoryadd"&gt;
&lt;table border="0"
cellspacing="0" cellpadding="0"&gt;
&lt;tr&gt;
&lt;td colspan="2" class="text" height="98"&gt; &lt;table border="0"
cellpadding="0" cellspacing="0"
style="border-collapse: collapse"
bordercolor="#111111" width="100%" id="AutoNumber6"&gt;
&lt;tr&gt;
&lt;td width="100%" bgcolor="#000066"
colspan="2"
style="border-left: 1px solid #CCCCFF; border-bottom: 1px solid #CCCCFF; padding: 1"&gt;
&lt;p style="margin-left: 5" class="10text"&gt;&lt;b&gt;&lt;font
color="#ffff00" size="2"&gt;&nbsp;&lt;br&gt;
PLEASE NOTE:&nbsp; Memories are added with&nbsp;
no editing so keep them clean and inoffensive.
Any person posting unacceptable material will
have all their details removed from the site.&lt;br&gt;
&nbsp;&lt;/font&gt;&lt;/b&gt; &lt;/p&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td width="64%" bgcolor="#000066"
style="border-left: 1px solid #CCCCFF; border-bottom: 1px solid #CCCCFF; padding: 1"&gt;
&lt;p
class="10text" style="margin-left: 5"&gt;&lt;font
color="#FFFFFF"&gt;&lt;b&gt;&lt;a name="top"&gt;&lt;font
face="Verdana, Arial, Helvetica, sans-serif"&gt;Add a Memory&lt;/font&gt;&lt;/a&gt;&lt;/b&gt;&lt;/font&gt;&lt;font
face="Verdana, Arial, Helvetica, sans-serif"&gt; &lt;/font&gt; &lt;/p&gt;&lt;/td&gt;
&lt;td width="36%" bgcolor="#000066"&gt;&nbsp; &lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td bgcolor="#000066" class="text" height="16"
style="border-left: 1px solid #CCCCFF; padding: 1"&gt;&lt;b&gt; &lt;font
face="Verdana, Arial, Helvetica, sans-serif"
color="#FFFFFF"&gt;&nbsp;&lt;/font&gt;&lt;/b&gt;&lt;/td&gt;
&lt;td height="16"&gt;&lt;b&gt; &lt;font
face="Verdana, Arial, Helvetica, sans-serif" size="2"&gt;You need to
complete ALL the boxes&lt;/font&gt;&lt;/b&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td bgcolor="#000066" class="text" height="32"
style="border-left: 1px solid #CCCCFF; border-bottom: 1px solid #CCCCFF; padding: 1"&gt;
&lt;p class="10text" style="margin-left: 5"&gt;&lt;font
face="Verdana, Arial, Helvetica, sans-serif"
color="#FFFFFF"&gt;Your Name&lt;/font&gt; &lt;font size="1"
face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"&gt;&lt;br&gt;
(while at SEECTHS)&lt;/font&gt; &lt;/p&gt;&lt;/td&gt;
&lt;td height="32"&gt;&lt;font
face="Verdana, Arial, Helvetica, sans-serif"&gt;
&lt;input
type="text" name="author" size="50"&gt;
&lt;/font&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td bgcolor="#000066" class="text" height="36"
style="border-left: 1px solid #CCCCFF; border-bottom: 1px solid #CCCCFF; padding: 1"&gt;
&lt;p class="10text" style="margin-left: 5"&gt; &lt;font
face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"&gt;Which
years were you at SEECTHS?&lt;/font&gt;&lt;/td&gt;
&lt;td height="36"&gt; &lt;input type="text" name="years"
size="20"&gt;
&lt;b&gt;&lt;font size="2"&gt;e.g. 1962&gt;67 or &gt;1967&lt;/font&gt;&lt;/b&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td bgcolor="#000066" class="text" valign="top" height="84"
style="border-left: 1px solid #CCCCFF; border-bottom: 1px solid #CCCCFF; padding: 1"&gt;
&lt;p class="10text" style="margin-left: 5"&gt; &lt;font face="Verdana, Arial, Helvetica, sans-serif"
color="#FFFFFF"&gt; Your Memory:&lt;/font&gt; &lt;/p&gt;&lt;/td&gt;
&lt;td height="84"&gt;&lt;font
face="Verdana, Arial, Helvetica, sans-serif"&gt;
&lt;textarea name="memories" rows="5" wrap="VIRTUAL" cols="50"&gt;&lt;/textarea&gt;
&lt;/font&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td colspan="2" align="center"&gt;&lt;font
face="Verdana, Arial, Helvetica, sans-serif"&gt; &lt;b&gt;
&lt;input
type="submit" name="Submit" value="Click to add your memory"

style="font-family: Verdana,Arial,Helvetica,'San Serif'; font-size: 10pt; font-weight: bold; color: #FFFFFF; background-color: #000066"&gt;
&lt;/b&gt; &lt;/font&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;input type="hidden" name="MM_insert" value="memoryadd"&gt;
&lt;/form&gt;
&lt;p class="text" align="center"&gt;&lt;b&gt; &lt;font
face="Verdana,Arial,Helvetica,San Serif" size="3"&gt; &lt;a
target="_self" href="memoriesindex.asp"&gt;Go back to Memories&lt;/a&gt;&lt;/font&gt;&lt;/b&gt;&lt;font size="2"&gt;&lt;/font&gt;&lt;/p&gt;
&lt;font size="2"&gt;
&lt;blockquote&gt;
&lt;p class="text"&gt;&nbsp;&lt;/p&gt;
&lt;/blockquote&gt;
&lt;/font&gt; &lt;p&gt;&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;p&gt;&lt;br&gt;
&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;p&gt;&nbsp;&lt;/p&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td colspan="2" valign="top" bgcolor="#000099"&gt;
&lt;!--#include file="copyright.asp" --&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;BR&gt;

&lt;div align="center"&gt;
&lt;table width="770" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#111111"
style="border-collapse: collapse"&gt;
&lt;center&gt;
&lt;tr&gt;
&lt;td width="120" valign="top" bgcolor="#000066"&gt;&nbsp;&lt;/td&gt;
&lt;td width="100%" colspan="2" valign="top"&gt;
&lt;center&gt;
&lt;/center&gt;

&lt;tr&gt;
&lt;td width="120"&gt;&nbsp;&lt;/td&gt;
&lt;td width="411"&gt;&nbsp;&lt;/td&gt;
&lt;td width="274"&gt;&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;/center&gt;
&lt;/table&gt;

&lt;/div&gt;
&lt;p&gt;&nbsp;&lt;/p&gt;
&lt;p&gt;&nbsp;&lt;/p&gt;
&lt;/body&gt;
&lt;/html&gt;
Replied 20 Sep 2007 16:45:56
20 Sep 2007 16:45:56 Doug Mouncey replied:
Thanks for your quick reply.

All though your code didn't directly get used as the fix, it made me think about some of the ASP being used.

The call for Request.ServerVariables("SCRIPT_NAME" was giving the incorrect path to work with the rest of the script.

I manually put in the name of the page and it all works fine now.

Thanks again

Doug
Replied 20 Sep 2007 17:58:07
20 Sep 2007 17:58:07 Pauline Bane replied:
Glad you've got it working - these things can be so frustrating and can take up so much time!

Reply to this topic