Converting WDDX Packet into sql server temp table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Converting WDDX Packet into sql server temp table

Author

Topic

na2173
Starting Member

38 Posts

Posted - 2005-06-22 : 18:03:05

I am trying to convert below string and insert data into a temp table. Does sql Server supports wddx packets.

<wddxPacket version='1.0'>
<header/>
<data>
<recordset rowCount='3' fieldNames='number,seperator,name'>
<field name='number'>
<string>10002</string>
<string>28018</string>
<string>28023</string>
</field>
<field name='seperator'>
<string> - </string>
<string> - </string>
<string> - </string>
</field>

<field name='name'>
<string>APPLIANCE PACKAGE 2</string>
<string>APPLIANCE PACKAGE 3</string>
<string>APPLIANCE PACKAGE 4</string>
</field>
</recordset>
</data>
</wddxPacket>

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-06-23 : 12:39:12

this seems to me like a little xml thing.
if this is a valid xml you can use OpenXML <- look it up in BOL
or you can fill a dataset with it and it can then be transformed into a relational model in .net

Go with the flow & have fun! Else fight the flow

nathans
Aged Yak Warrior

938 Posts

Posted - 2005-06-23 : 14:39:51

SQL Server doesnt directly support WDDX, but ColdFusion has many methods of serializing WDDX into XML, which as Mladen mentioned, IS supported.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources