Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSI

Posted on 2003-10-30
7
Medium Priority
?
382 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 58

Accepted Solution

by:
Gary earned 500 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are two main kinds of selectors in CSS: One is base selector like h1, h2, body, table or any existing HTML tags.  For instance, the following rule sets all paragraphs (<p> elements) to red: (CODE) CSS also allows us to define our own custom …
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
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.
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

688 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