Hiding Tags

The following code does exactly what i want, which is pull the info from the db and display it... wooo hoooo..

the problem is it also shows the tags !!

so the question is ... how do i hide them ?




<?xml version="1.0" encoding="ISO-8859-1"?>
<MESSAGELIST>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "textodbc"
Set Tape = Conn.Execute("select * from users")
Do While Not Tape.EOF
%>

<TEXTMESSAGE>
<USERNAME><%=Tape("USERNAME")%></USERNAME>
<PWORD><%=Tape("PWORD")%></PWORD>
<REF><%=Tape("REF")%></REF>
<GSMNO><%=Tape("GSMNO")%></GSMNO>
<CONTENT><%=Tape("CONTENT")%></CONTENT>
</TEXTMESSAGE>



<% Tape.MoveNext
Loop
%>
</MESSAGELIST>

shows all the tags? You mean in IE? You mean you see the default IE view of XML .. i.e red and blue formatted XML?

What do you expect instead?

yep thats exactly what i mean ... in ie it shows all the coloured tags .. i would like to see just the data and not the tags ..

steve

err...

what kind of document is this ASP? XML? XSL?

sorry ... asp.

steve

and how do you want to see it? with tags? or just with the tag content? and what about tag attributes?
you'll have to be precise mate...give us a sample of what you want to see..

sorry. i thought i had been quite precise with

"the problem is it also shows the tags !!

so the question is ... how do i hide them ?"

I dont want to see the tags i ONLY want to see the data (no tags ...no tag attributes) just the data.

I want to see

steve
spanners
01511
4478454874547
this is a test

not

<USERNAME>steve</USERNAME
<PWORD>spanners</PWORD>
<REF>01511</REF>
<GSMNO>4478454874547</GSMNO>
<CONTENT>this is a test</CONTENT>

i have seen it before where the screen output was just the text .. the source code contained the tags and there was defo no XSL involved in that .. getting back to that would do me if you have any ideas how???

i have had the data displaying the way i want in the past but have overwritten the file working on different versions and i dont know how to write XSL so like i said there was "defo no XSL in that" ..any more ideas ...

and just to prove it .... check out

http://www.rs-design.uk.com/sms/list2.asp

and the problem with that script is it doesnt loop ... when i try the 2 together i get the problem i mentioned in my first mail...

Someone must know a fix for this ..

Please HELP me

this one has no <htm> tags and still gives me the desired result but with no loop (and no XSL)

http://www.rs-design.uk.com/sms/list7.asp

ok .. that makes sense ... can you tell me why when i just removed the <?xml... from http://www.rs-design.uk.com/sms/list5.asp that shows a different result ? (with tags )

I'm no wizzard with XSL, so I used XMLSPY and created a schema for my xml file, then used the style sheet designer that came with xmlspy and created a style sheet for that schema and associated it with my xml files. worked perfectly.

On the down side, xmlspy costs money, so I only dl'd the trial version of it, but I'm sure there are freeware alternatives out there if you want to avoid doing it all manually.

Cheers.