Stratocaster
asked on
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.Conn ection")
conn.Provider="Microsoft.J et.OLEDB.4 .0"
conn.Open "C:\Inetpub\wwwroot\asp\Or ders.mdb"
%>
<%
set rs=Server.CreateObject("AD ODB.record set")
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\a sp\ADO\con signee.asp "-->
If anyone knows why this might not work I would appreciate any help.
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("
conn.Provider="Microsoft.J
conn.Open "C:\Inetpub\wwwroot\asp\Or
%>
<%
set rs=Server.CreateObject("AD
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\a
If anyone knows why this might not work I would appreciate any help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad you got it sorted but why the grade of B?
ASKER
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.
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.
ASKER
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
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
ASKER
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