select -> xml file?

[Lasse Edsvik]

Hello

Im trying to build a simple page that outputs xml. but i dont see the
browser understand that contenttype or something like that since the nodes
arent "clickable", i need to use view source to see it....... was wondering
if there is an other way of doing this or if this is the best way, or if
there is something i can add so the browser treat the content as it would if
i open up a xml file in explorer.


<%
response.contenttype = "text/xml"

'i open db here
sql="select * from employees"
set rs=conn.execute(sql)

response.write("<?xml version=""1.0"" encoding=""UTF-8""?>")
response.write("<ROOT>")

if not rs.eof then
do until rs.eof
response.write("<Employee>"&rs("employee")&"</Employee>")

rs.movenext
loop
end if
set conn=nothing

response.write("</ROOT>")
%>


/Lasse

[Bob Barrows]

Lasse Edsvik wrote:

> Hello
>
> Im trying to build a simple page that outputs xml. but i dont see the
> browser understand that contenttype or something like that since the
> nodes arent "clickable", i need to use view source to see it.......
> was wondering if there is an other way of doing this or if this is
> the best way, or if there is something i can add so the browser treat
> the content as it would if i open up a xml file in explorer.
>
>
> <%
> response.contenttype = "text/xml"
>
> 'i open db here
> sql="select * from employees"
> set rs=conn.execute(sql)
>
> response.write("<?xml version=""1.0"" encoding=""UTF-8""?>")
> response.write("<ROOT>")
>
> if not rs.eof then
> do until rs.eof
> response.write("<Employee>"&rs("employee")&"</Employee>")
>
> rs.movenext
> loop
> end if
> set conn=nothing
>
> response.write("</ROOT>")
> %>
>
>
> /Lasse

If I change your code to this (commenting out the ADO code):
<%
response.contenttype = "text/xml"

'i open db here
' sql="select * from employees"
'set rs=conn.execute(sql)

response.write "<?xml version=""1.0"" encoding=""UTF-8""?>"
response.write "<ROOT>"

'if not rs.eof then
' do until rs.eof
' response.write("<Employee>"&rs("employee")&"</Employee>")
response.write "<Employee>A</Employee>"
' rs.movenext
' loop
'end if
'set conn=nothing

response.write "</ROOT>"
%>

I see the proper result in the browser. Do you?

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Lasse Edsvik]

Bob,

I need to use view source to see all elements and structure.......

i use IE6

/Lasse


"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eDg04eS1DHA.2544@TK2MSFTNGP10.phx.gbl...

> Lasse Edsvik wrote:

> > Hello
> >
> > Im trying to build a simple page that outputs xml. but i dont see the
> > browser understand that contenttype or something like that since the
> > nodes arent "clickable", i need to use view source to see it.......
> > was wondering if there is an other way of doing this or if this is
> > the best way, or if there is something i can add so the browser treat
> > the content as it would if i open up a xml file in explorer.
> >
> >
> > <%
> > response.contenttype = "text/xml"
> >
> > 'i open db here
> > sql="select * from employees"
> > set rs=conn.execute(sql)
> >
> > response.write("<?xml version=""1.0"" encoding=""UTF-8""?>")
> > response.write("<ROOT>")
> >
> > if not rs.eof then
> > do until rs.eof
> > response.write("<Employee>"&rs("employee")&"</Employee>")
> >
> > rs.movenext
> > loop
> > end if
> > set conn=nothing
> >
> > response.write("</ROOT>")
> > %>
> >
> >
> > /Lasse

>
> If I change your code to this (commenting out the ADO code):
> <%
> response.contenttype = "text/xml"
>
> 'i open db here
> ' sql="select * from employees"
> 'set rs=conn.execute(sql)
>
> response.write "<?xml version=""1.0"" encoding=""UTF-8""?>"
> response.write "<ROOT>"
>
> 'if not rs.eof then
> ' do until rs.eof
> ' response.write("<Employee>"&rs("employee")&"</Employee>")
> response.write "<Employee>A</Employee>"
> ' rs.movenext
> ' loop
> 'end if
> 'set conn=nothing
>
> response.write "</ROOT>"
> %>
>
> I see the proper result in the browser. Do you?
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

[Bob Barrows]

Lasse Edsvik wrote:

> Bob,
>
> I need to use view source to see all elements and structure.......
>
> i use IE6
>
> /Lasse
>

I'm using IE6 as well, and I definitely see the XML without viewing source.
When you view source, does the xml look correct? If it's not too much data,
could you post the source so we can see if there are any problems with it?

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Lasse Edsvik]

Bob,

yep, its correct, to test i took some data from the source and saved it as
text.xml and then it showed up properly in the browser. Tried with only 1
row too, same result.......

some content-type problem going on?

/Lasse

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23vAD$lS1DHA.2412@TK2MSFTNGP10.phx.gbl...

> Lasse Edsvik wrote:

> > Bob,
> >
> > I need to use view source to see all elements and structure.......
> >
> > i use IE6
> >
> > /Lasse
> >

>
> I'm using IE6 as well, and I definitely see the XML without viewing

source.

> When you view source, does the xml look correct? If it's not too much

data,

> could you post the source so we can see if there are any problems with it?
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

[Bob Barrows]

Lasse Edsvik wrote:

> Bob,
>
> yep, its correct, to test i took some data from the source and saved
> it as text.xml and then it showed up properly in the browser. Tried
> with only 1 row too, same result.......
>
> some content-type problem going on?
>

No clue - I've never seen this problem. Normally, I would try Google at this
point, but I don't have much time this morning so I suggest you try it
yourself.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Brynn]

Can you put a sample of the page up somewhere where we can try to view
it?

On Wed, 7 Jan 2004 15:18:40 +0100, "Lasse Edsvik" <lasse@nospam.com>
wrote:

>Bob,
>
>I need to use view source to see all elements and structure.......
>
>i use IE6
>
>/Lasse
>
>
>"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
>news:eDg04eS1DHA.2544@TK2MSFTNGP10.phx.gbl...

>> Lasse Edsvik wrote:

>> > Hello
>> >
>> > Im trying to build a simple page that outputs xml. but i dont see the
>> > browser understand that contenttype or something like that since the
>> > nodes arent "clickable", i need to use view source to see it.......
>> > was wondering if there is an other way of doing this or if this is
>> > the best way, or if there is something i can add so the browser treat
>> > the content as it would if i open up a xml file in explorer.
>> >
>> >
>> > <%
>> > response.contenttype = "text/xml"
>> >
>> > 'i open db here
>> > sql="select * from employees"
>> > set rs=conn.execute(sql)
>> >
>> > response.write("<?xml version=""1.0"" encoding=""UTF-8""?>")
>> > response.write("<ROOT>")
>> >
>> > if not rs.eof then
>> > do until rs.eof
>> > response.write("<Employee>"&rs("employee")&"</Employee>")
>> >
>> > rs.movenext
>> > loop
>> > end if
>> > set conn=nothing
>> >
>> > response.write("</ROOT>")
>> > %>
>> >
>> >
>> > /Lasse

>>
>> If I change your code to this (commenting out the ADO code):
>> <%
>> response.contenttype = "text/xml"
>>
>> 'i open db here
>> ' sql="select * from employees"
>> 'set rs=conn.execute(sql)
>>
>> response.write "<?xml version=""1.0"" encoding=""UTF-8""?>"
>> response.write "<ROOT>"
>>
>> 'if not rs.eof then
>> ' do until rs.eof
>> ' response.write("<Employee>"&rs("employee")&"</Employee>")
>> response.write "<Employee>A</Employee>"
>> ' rs.movenext
>> ' loop
>> 'end if
>> 'set conn=nothing
>>
>> response.write "</ROOT>"
>> %>
>>
>> I see the proper result in the browser. Do you?
>>
>> Bob Barrows
>> --
>> Microsoft MVP -- ASP/ASP.NET
>> Please reply to the newsgroup. The email account listed in my From
>> header is my spam trap, so I don't check it very often. You will get a
>> quicker response by posting to the newsgroup.
>>
>>

>
>