Solved

SSI

Posted on 2003-10-30
7
314 Views
Last Modified: 2010-04-06
Hey,
   I'm pretty new to asp but I'm working on a page that uses it and has two ADO connections. A friend of mine suggested that instead of putting the ADO code in the main page that I use a SSI, which I thought was great but then realized that I couldn't get it to work. Anyway here is what the code looks like.
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:\Inetpub\wwwroot\asp\Orders.mdb"
%>
<%
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select [DEALER NAME], Address, CITY, STATE, Zip From [CURRENT ORDERS] WHERE ORIGIN='Z00'", conn
%>
<%
for each x in rs.Fields
      Response.Write(x.value & "<br />")
%>
      <%next%>

This is the file included with this string
<--!#include file="C:\Inetpub\wwwroot\asp\ADO\consignee.asp"-->

If anyone knows why this might not work I would appreciate any help.
0
Comment
Question by:Stratocaster
  • 3
  • 2
7 Comments
 
LVL 58

Accepted Solution

by:
Gary earned 125 total points
ID: 9655883
You shouldn't put the literal path in the include tag e.g.

If the include file is in the same folder
<--!#include file="consignee.asp"-->

If its in folders below the current folder prefix the folder path to the filename
<--!#include file="asp\ADO\consignee.asp"-->

If you want to go up a directory (and then down another folder path, ../ tells the server to go up one folder level
<--!#include virtual="../asp/ADO/consignee.asp"-->
0
 

Author Comment

by:Stratocaster
ID: 9658151
Gary,
   Thanks for the reply. I actually figured out after I posted this question that I didn't need the full pathname in the include but, since you had the right answer the points are yours.

Thanks again.

Stratocaster
0
 
LVL 58

Expert Comment

by:Gary
ID: 9658655
Glad you got it sorted but why the grade of B?
0
 

Author Comment

by:Stratocaster
ID: 9658707
Gary,
   Tha only reason I didn't post an A is because the A grade seemed to be for over-achievement like posting links to reference materials and that sort of thing. You got an A in my book though.

I really do appreciate the help Gary.

Thanks,
     Stratocaster.
0
 

Author Comment

by:Stratocaster
ID: 9670551
Lunchy,
     Thanks for the post. I do understand the grading policy.. in fact I re-read it right before I awarded a grade to this reply. I was however in a bit of a rush since I was at work while I was replying to this response. I do think that Gary should receive an A for his post. It did after all effectively answer the question I posted. I apologize to Gary for mis-grading his answer.


Thanks,
    Stratocaster
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now