XML DOM

[Harishp]

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(&quot;ADODB.connection&quot
conn.open &quot;DSN=somedsn&quot;
set rs=server.createobject(&quot;ADODB.Recordset&quot
rs.open &quot;select * from table&quot;,conn
if rs.eof=false then
rs.Save Response, adPersistXML
else
response.write(&quot;No data available&quot
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>

Thanks

Harish

 

[palbano]

> I am getting junk data on the browser from this code.

'junk data'

Slightly ambiguous. Perhaps you could elaborate?
-pete

 

[Harishp]

Hi,

Following is sample out put from a database which contains some product details.

following is the &quot;junk data&quot;
=======================================================

TG!  ¶’ò?²Ï# ª _þX
! Ò­cöëÏ°ã ª ?    ÿÿÿÿ@  ¾&quot;µÈó\Î­å ª Dw=   †  I  Á<Ž¶ëmЍö ª _þX ) €

 a g e n c y ‚ ÿ ÿ ÿ d ÿÿ/ €
 p r o d _ l i n e ‚ ÿ ÿ ÿ d ÿÿ1 €

p r o d _ g r o u p ‚ ÿ ÿ ÿ d ÿÿ/ €
 i t e m _ c o d e ‚ ÿ ÿ ÿ d ÿÿ/ €
 i t e m _ d e s c ‚ ÿ ÿ ÿ d ÿÿ1 €

l i s t _ p r i c e    ÿ t ÿÿÿ C H U R C H I L  T A B L E W A R E K I T C H E N U T E N S I L S  B R O S C J C - 1  C R E A M J U G C H E L ffffff@ÿ C H U R C H I L  T A B L E W A R E K I T C H E N U T E N S I L S  C G - C S G E 1  C O V S G R M E R I D 333333@ÿ C H U R C H I L  T A B L E W A R E K I T C H E N U T E N S I L S  S G D N T P E - 1  T E A P O T M D &@ÿ C H U R C H I L  T A B L E W A R E K I T C H E N U T E N S I L S  W I - C J G - 1  C R E A M J U G G E O 9@ÿ C H U R C H I L  T A B L E W A R E K I T C H E N U T E N S I L S  W I - P 2 0 M 3  P L A T E 2 0 C M M T 9@ÿ C H U R C H I L  T A B L E W A R E K I T C H E N U T E N S I L S  W I - T G - 3  T E A C U P G E O R G I A N 9@ÿ D I M A  T A B L E W A R E  C R O C K E R Y
A L 0 1 6  G O L F P U T T E R 9@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E  T R I P O D  1 5 . 6 E V  T R I P O D ‰A`åÐâ&quot;@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E &quot; E N E R G Y S A V E R B U L B  1 5 W E 2 7  1 5 W L A M P S ü©ñÒMb@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E &quot; E N E R G Y S A V E R B U L B  1 5 W B 2 2  1 5 W L A M P P ü©ñÒMb@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E &quot; E N E R G Y S A V E R B U L B  A J 2 5 W B 2 2  2 5 W L A M P P 9@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E &quot; E N E R G Y S A V E R B U L B  A J 2 0 W B 2 2  2 0 W L A M P P 9@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E &quot; E N E R G Y S A V E R B U L B
9 W E 2 7  2 7 W L A M P S  /Ý$†@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E  V I S I O N  8 X 4 0 F S  B I N O C U L A R ®GázŽ9@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E &quot; E N E R G Y S A V E R B U L B  2 5 W E 2 7  2 5 W L A M P S ü©ñÒMb@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E &quot; E N E R G Y S A V E R B U L B  2 5 W B 2 2  2 5 W L A M P P ü©ñÒMb@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E  V I S I O N  2 0 X 5 0 F S  B I N O C U L A R •C‹üA@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E &quot; E N E R G Y S A V E R B U L B  2 0 W E 2 7  2 0 W L A M P S ü©ñÒMb@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E  V I S I O N  P C 7 - 2 1 X 2 5 I R  B I N O C U L A R /Ý$uL@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E
V I D E O  N V 1 8 2 S  V I D E O B A G @ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E
V I D E O  N V 1 8 2 M  V I D E O B A G ð§ÆK7É#@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E
A U D I O
L C 7 0 1 A U D I O C D C L E A N E R mçû©ñÒ @ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E  E M E R G E N C Y L I G H T
D L 7 4 7  G A M A S O N I C L I G H T (@ÿ4 A A L J A A F A R T R A D I N G C O M P A N Y  T A B L E W A R E  E M E R G E N C Y L I G H T  D L 7 1 5 C  G A M A S O N I C L I G H T $@ÿ4 A A L J A A F A R T R A D I N G
=======================================================

well I hope this will give you some idea. I have MS XML3 parser the latest and ADO 2.6 on W2k

Thanks
Harish

 

[palbano]

Harish,

Well if the data in your table is good I would say there is a problem with the ADODB XML conversion.

-pete