SQLXML ASP Truncation Problem

[fcmuffin]

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.

[russell]

can we see the code for sp_ItemXML

[fcmuffin]

SELECT 1 AS Tag,
Null AS Parent,
CategoryID AS [category!1!id],
Category AS [category!1!name!element],
CategoryDesc AS [category!1!desc!element],
Null AS [item!2!id],
Null AS [item!2!username!element],
Null AS [item!2!name!element],
Null AS [item!2!price!element],
Null AS [item!2!jdial!element],
Null AS [item!2!space!element],
Null AS [item!2!qty!element],
Null AS [item!2!desc!element],
Null AS [item!2!image!element],
Null AS [item!2!date!element]
FROM tblCategory C
UNION ALL
SELECT 2,
1,
C.CategoryID,
C.Category,
C.CategoryDesc,
I.ItemID,
I.UserComposeName,
I.ItemName,
I.ItemPrice,
I.ItemJDial,
I.ItemSpace,
I.ItemQTY,
I.ItemDesc,
I.ItemImage,
I.ItemDate
FROM tblCategory C
JOIN tblItem I
ON C.CategoryID = I.CategoryID
ORDER BY [category!1!id], [item!2!id]
FOR
XML EXPLICIT

[fcmuffin]

Well there seemed to have been a problem in my ASP. I should have used a "Do..Loop" Statement Rather than a "For..Next" heres the working code:
<% Response.ContentType = "text/xml" %>
<?xml version="1.0"?>
<root>
<%
Dim objCN, objSP, i
Set objCN = Server.CreateObject("ADODB.Connection")
objCN.Open "DSN=dbTradingPost;"
Set objSP = objCN.Execute("sp_ItemXML")
Do Until objSP.EOF
Response.Write objSP(0)
objSP.MoveNext
Loop
objCN.Close
set objCN = nothing
%>
</root>
anyways, thanks for all your guys help.