Hi All,
I am getting junk data on the browser from this code. Can anybody tell me what is wrong in the code? I am running the latest MSXML parser on W2K
<%
dim conn,rs,xmldom
dim strr
set conn=server.createobject("ADODB.connection"
conn.open "DSN=somedsn"
set rs=server.createobject("ADODB.Recordset"
rs.open "select * from table",conn
if rs.eof=false then
rs.Save Response, adPersistXML
else
response.write("No data available"
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
Thanks
Harish
I am getting junk data on the browser from this code. Can anybody tell me what is wrong in the code? I am running the latest MSXML parser on W2K
<%
dim conn,rs,xmldom
dim strr
set conn=server.createobject("ADODB.connection"
conn.open "DSN=somedsn"
set rs=server.createobject("ADODB.Recordset"
rs.open "select * from table",conn
if rs.eof=false then
rs.Save Response, adPersistXML
else
response.write("No data available"
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
Thanks
Harish