Display a file residing on a different server?

Herring · Jul 26, 2002

I have an asp page on one server/domain, let's call it

http://www.domain1.com/myTable.asp

that generates a table from a database that also resides on that server.

I would like to display myTable.asp on another page on a different server which doesn't have asp support

http://www.domain2.com/plain_file.htm

I have tried including the following line where I want the table to be displayed in plain_file.htm
<script language="VBScript" src=

http://www.domain1.com/myTable.asp></script>

It seems to go there but then I get error upon error popping up.
Line 3: Expected Statement
When I open up the debugger from IE, all the HTML code is correctly placed, the table is populated with the correct information.

I have removed HTML, HEAD,/HEAD, BODY, /BODY and /HTML tags from myTable.asp.

myTable.asp displays fine if viewed on it's own.

realgaz · Jul 26, 2002

I should think that you either have a problem in your code somewhere. More than likly its a silly thing like a ";" missing or something spelt incorretly.

I hate suggesting using frames..but it might work. You could load the asp page into another frame in the window. Although frames are horrid i find and make the window look a mess when the browser is resized by the user.

Herring · Jul 27, 2002

Thanks for your reply Realgaz. I guess I didn't have email notification checked.
Following is the code from the 2 files involved. I've been messing around with it so long I think I've gone blind. I guess that's what happens when one only tries scripting every few months.

Any takers?

--------------------------------------------
This is

http://www.domain2.com/plain_file.htm

--------------------------------------------
<html>
<head></head>
<body>
Regular HTML stuff in here.......

<SCRIPT LANGUAGE="JavaScript" src="

http://www.domain1.com/myTable.asp"></script>

</body>
</html>

--------------------------------------------
And the following is the

http://www.domain1.com/myTable.asp

file stored on

http://www.domain.com

--------------------------------------------

<%@LANGUAGE="VBSCRIPT"%>
<%
SET CONN1 = Server.CreateObject("ADODB.Connection&quot

Set RS = Server.CreateObject("ADODB.RecordSet&quot

AccessConnect = "DSN=realestate;"
SQLQuery = "SELECT ListingNo, Category, Neighbourhood, Style, Area, Price FROM Listing where DateApproved <= Date()and (SaleTypeID = 3 or SaleTypeID = 1) and DateSold is null and (DateRemove is null or DateRemove >= date())order by Price"
RS.Open SQLQuery, AccessConnect
%>
<%
Response.Write("<TABLE width='700' align='Center' border='0' cellspacing='0' cellpadding='3'>&quot

Response.Write("<TR><br>&quot

Response.Write("<TD colspan='2'><a href='

http://www.domain1.com'><img

src='images/logo_s.gif' border='0'></a></TD><br>&quot

Response.Write("<TD colspan='4' align='center'><H2>Properties for sale and for rent.</H2></TD><br>&quot

Response.Write("</TR><br>&quot

Response.Write("<TR><br><TD colspan='6'>Properties for Sale</TD><br>&quot

Response.Write("</TR><br>&quot

Response.Write("<TR><br>&quot

Response.Write("<TD>Category</TD><br>&quot

Response.Write("<TD>Style</TD><br>&quot

Response.Write("<TD>Area</TD><br>&quot

Response.Write("<TD>Neighbourhood</TD><br>&quot

Response.Write("<TD>Price</TD><br>&quot

Response.Write("<TD>Details</TD><br>&quot

Response.Write("</TR>&quot

%>

<% if not RS.eof then
RS.MoveFirst
While NOT RS.eof
%>
<% if intRowColor = 0 Then
Response.Write("<TR bgcolor='green'>&quot

intRowColor = 1
Else
Response.Write("<TR bgcolor='red'>&quot

intRowColor = 0
End if
%>
<%
Response.Write("<TD width='150'>" & RS("Category&quot

& "</TD><br>&quot

Response.Write("<TD width='150'>" & RS("Style&quot

& "</TD><br>&quot

Response.Write("<TD width='150'>" & RS("Area&quot

& "</TD><br>&quot

Response.Write("<TD width='125'>" & RS("Neighbourhood&quot

& "</b></TD><br>&quot

Response.Write("<TD width='75'>" & RS("Price&quot

& "</TD><br>&quot

Response.Write("<TD width='50'><a href='

http://www.domain1.com/detail.asp?ListingNo="

& RS("ListingNo&quot

& "'>Details</a></TD><br>&quot

Response.Write("</TR>&quot

%>
<%
RS.MoveNext
Wend
End if
%>
<%
Set RS=Nothing
Set CONN1=nothing
%>
<%
Response.Write("</TABLE>&quot

%>

trollacious · Jul 27, 2002

When you load a file with <script> tags, it's like putting <script> and </script> around the code on your page. Since none of the ASP page you're loading is actually Javascript, it's GOING to error.

Try, in the HTML file, putting:

<script>
<TABLE width='700' align='Center' border='0' cellspacing='0' cellpadding='3'>
<tr><td>Inside Script</td></tr>
</table>
</script>

and see what happens. It looks like what you want to load it as a Server Side Include (SSI), not as a script.

Herring · Jul 28, 2002

Trollacious - There are a couple of problems with this.
1 - The server/site the plain_file.htm resides on doesn't support SSI or ASP.
2 - The database is also on another site's server.

I'm obviously missing something here. Been staring at and messing around with this for too long.

trollacious · Jul 28, 2002

What you're doing is exactly like putting HTML code inside script tags with no document.write() method. You can't do what you want the way you're trying to do it. If you want to load the file as a Javascript file, you have to write it as a Javascript file, no matter WHAT you name it.

The example I gave you:

<script>
<TABLE width='700' align='Center' border='0' cellspacing='0' cellpadding='3'>
<tr><td>Inside Script</td></tr>
</table>
</script>

shows what you're ACTUALLY doing by trying to load an ASP file inside <script>...</script> tags, and should be obvious why it won't work.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Display a file residing on a different server?

Herring

Technical User

realgaz

Programmer

Herring

Technical User

trollacious

Programmer

Herring

Technical User

trollacious

Programmer

Similar threads

Part and Inventory Search

Sponsor