• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

SSI

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
Stratocaster
Asked:
Stratocaster
  • 3
  • 2
1 Solution
 
GaryCommented:
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
 
StratocasterAuthor Commented:
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
 
GaryCommented:
Glad you got it sorted but why the grade of B?
0
 
StratocasterAuthor Commented:
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
 
StratocasterAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now