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.
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 />")
This is the file included with this string
If anyone knows why this might not work I would appreciate any help.