Set Retrieval = Server.CreateObject("Microsoft.XMLHTTP")
With Retrieval
.Open "GET", url, false, "", ""
.Send
End With
Set Retrieval = Nothing
如果发送POST数据呢?.Open参数的具体意义是什么?
或者谁有具体的资料,能提供的话要多少分尽管说。
...全文
498打赏收藏
求教 Microsoft.XMLHTTP 的问题,在线等待...
Set Retrieval = Server.CreateObject("Microsoft.XMLHTTP") With Retrieval .Open "GET", url, false, "", "" .Send End With Set Retrieval = Nothing 如果发送POST数据呢?.Open参数的具体意义是什么? 或者谁有具体的资料,能提供的话要多少分尽管说。
<%
on error resume next
'set conn=server.createobject("adodb.connection")'
' conn.open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=kyoa;Data Source=127.0.0.1"
'dim lsh,mc,xh,dw,jhj,fl
Response.ContentType = "text/xml"
Response.CharSet="UTF-8"
set xmldom = server.CreateObject("Microsoft.XMLDOM")
xmldom.load(Request)
'xmldom.save(response)
'Response.End
'return = "<SOAP:Envelope xmlns:SOAP=""urn:a""><SOAP:Body><message><theword>XML will Set You Free! My God!</theword><book><bookname>The candle in wind!</bookname><author>jacky zhang</author><price>1234.00</price></book></message></SOAP:Body></SOAP:Envelope>"
'xmldom.save(response)
'xmldom.save(server.mappath("\")&"\bg\sample.xml")
'str=str&"<SOAP:Envelope xmlns:SOAP=""urn:a""><SOAP:Body><girl><name>rose</name><age>12</age></girl></SOAP:Body></SOAP:Envelope>"
'分析xml文档
j=cint(trim(xmldom.documentElement.childNodes.item(0).childNodes.item(0).text))
'得到修改和新增的总次数(j)
'Response.Write "<message><goodnews>"&j&"</goodnews></message>"
'Response.End
set rs=server.CreateObject("adodb.recordset")
conn.BeginTrans
for i=1 to j step 1
id=cstr(trim(xmldom.documentElement.childNodes.item(i).childNodes.item(0).text))
sql="delete from bg_xxwh where lsh='"&id&"'"
conn.Execute sql
if err.number<>0 then
conn.RollbackTrans
end if
lsh=cstr(trim(xmldom.documentElement.childNodes.item(i).childNodes.item(0).text))
mc=cstr(trim(xmldom.documentElement.childNodes.item(i).childNodes.item(1).text))
xh=cstr(trim(xmldom.documentElement.childNodes.item(i).childNodes.item(2).text))
dw=cstr(trim(xmldom.documentElement.childNodes.item(i).childNodes.item(3).text))
jhj=cdbl(trim(xmldom.documentElement.childNodes.item(i).childNodes.item(4).text))
fl=cstr(trim(xmldom.documentElement.childNodes.item(i).childNodes.item(5).text))
strsql="insert into bg_xxwh(lsh,mc,xh,dw,jhj,fl) values('"&lsh
strsql=strsql&"','"&mc
strsql=strsql&"','"&xh
strsql=strsql&"','"&dw
strsql=strsql&"',"&jhj
strsql=strsql&",'"&fl&"')"
conn.Execute strsql
if err.number<>0 then
conn.RollbackTrans
end if
next
conn.CommitTrans
'err.number=0
errstr="<message><goodnews>succeed!!!</goodnews></message>"
if err.number<>0 then
Response.Write "<message><badnews>is wrong!do it again!</badnews></message>"
'Response.Write "<man><kill>aaaa</kill><err>sadas "&Err.description&"</err></man>"
else
Response.Write errstr
end if
%>