Today I did a test and found that when the "name" keywords used in the XML data returned by WebService as a healthy value, the ASP page will not be able to read the entire XML document, and the following errors appear:
The XML page cannot be displayed.
The XML input cannot be viewed using the XSL style table. Please correct the error and then click the refresh button, or try it later.
------------------------------------------------ ----------------------------------------------------------------------------
Interesting characters were found in the text content. Turning the resource 'http://192.168.0.41/aspserver/server.asp' errors. Line 56, Location: 11
<Name>
// The ASP code on the server side is as follows, and the WebService code is slightly, as long as you return a dataset value
<%
set objhttp = server.createObject (msxml2.xmlhttp)
set xmldoc = server.createObject (msxml.Document)
StrWebServiceURL = http://192.168.0.41/webservice1/service1.asmx/ds
'Set parameter and its value
'Strrequest = x = 2 & y = 3
strrequest = tbname = 123
objhttp.open post, StrWebServiceUrl, FALSE
'Set this Content-Type is important
Objhttp.setRequestHeader Content-Type, Application/X-WWW-Form-Urlencoded
objhttp.send (Strrequest)
BOK = xmldoc.load (Objhttp.Responsexml)
'Look at the state value
if objhttp.status = 200 then
xmlstr = xmldoc.xml
XMLSTR = Replace (xmlstr, & lt;, <, 1, -1,1)
XMLSTR = Replace (xmlstr, & gt;,>, 1, -1,1)
response.write xmlstr
else
response.write objhttp.status & <br>
response.write objhttp.statustext
end if
%>
'Keyword Name cannot be used in database design! Intersection Intersection Intersection Intersection Intersection Intersection Intersection Intersection Intersection Intersection Intersection
'100,000 attention! Intersection Intersection