Well my problem is that when I use SQLXML to load XML data from teh server if the data is larger than 2038 characters it truncates it and I get an XML Parse Error. Here is my code:
<% Response.ContentType = "text/xml" %>
<?xml version="1.0"?>
<root>
<%
Dim objCN, objSQL, i
Set objCN = Server.CreateObject("ADODB.Connection")
objCN.Open "DSN=dbTradingPost;"
objSQL = objCN.Execute("sp_ItemXML")
For Each i in objSQL
Response.Write(i)
Next
objCN.Close
set objCN = nothing
%>
</root>
Can anyone help me out with this, it is really getting to be bothersome as I would like to get more into XML.
<% Response.ContentType = "text/xml" %>
<?xml version="1.0"?>
<root>
<%
Dim objCN, objSQL, i
Set objCN = Server.CreateObject("ADODB.Connection")
objCN.Open "DSN=dbTradingPost;"
objSQL = objCN.Execute("sp_ItemXML")
For Each i in objSQL
Response.Write(i)
Next
objCN.Close
set objCN = nothing
%>
</root>
Can anyone help me out with this, it is really getting to be bothersome as I would like to get more into XML.