I am trying to get an XML document of all of my companies products so we can pass this on to vendors and affiliates to use to sell our items on their sites.
You can see the sample page I am working on at,
http://www.collegejersey.com/store/xmlsample.asp however if you scroll to the bottom there is an error.
/*************************
Error Below
XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------
----------
----------
----------
----------
----------
----
A semi colon character was expected. Error processing resource '
http://www.collegejersey.com/store/xmlsample.asp'. Line 1,...
/*************************
My ASP page is pretty simple and is below...
/*************************
My Code
<%@LANGUAGE="VBSCRIPT"%>
<%
response.ContentType = "text/xml"
set conn=Server.CreateObject("
ADODB.Conn
ection")
conn.open "Driver={SQL Server};UID=REMOVED;passwo
rd=REMOVED
;DATABASE=
REMOVED;SE
RVER=REMOV
ED"
sql="select sku, team, bowl, first_name, last_name, gw_ti, color, number, size, year, cut, details, price, imageFUrl, imageBUrl, smallImageUrl from products WHERE (stock > 0) AND (listHidden = 0) AND (active = -1)"
set rs=Conn.Execute(sql)
rs.MoveFirst()
response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")
response.write("<inventory
>")
while (not rs.EOF)
response.write("<product>"
)
response.write("<sku>" & rs("sku") & "</sku>")
response.write("<team>" & rs("team") & "</team>")
response.write("<first_nam
e>" & rs("first_name") & "</first_name>")
response.write("<last_name
>" & rs("last_name") & "</last_name>")
response.write("<game_used
>" & rs("gw_ti") & "</game_used>")
response.write("<number>" & rs("number") & "</number>")
response.write("<size>" & rs("size") & "</size>")
response.write("<color>" & rs("color") & "</color>")
response.write("<cut>" & rs("cut") & "</cut>")
response.write("<year>" & rs("year") & "</year>")
response.write("<price>" & rs("price") & "</price>")
response.write("</product>
")
rs.MoveNext()
wend
rs.close()
conn.close()
response.write("</inventor
y>")
%>
/*************************
Thanks for any help you can provide.
Sean
Start Free Trial