×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Calgary

请问有没有哪为兄弟知道how to using ASP script to input a XML file into a SQL server table????xml code is inside..

shinning(dudu)
<?xml version="1.0" encoding="en-US" standalone="yes"?>
<!-- Generated by Softsilver Transformer 2.3 *** UNREGISTERED *** (http://www.softsilver.com) -->
<document>
<row>
<SOURCE>40532</SOURCE>
<CLIENT>EAST</CLIENT>
<RECEIPT__NUMBER>14585</RECEIPT__NUMBER>
<UNITS>60</UNITS>
<SMAL>0</SMAL>
<AVER>0</AVER>
<LARG>0</LARG>
<RVPK>1</RVPK>
<PALL>0</PALL>
</row>
<row>
<SOURCE>40532</SOURCE>
<CLIENT>EAST</CLIENT>
<RECEIPT__NUMBER>14585</RECEIPT__NUMBER>
<UNITS>60</UNITS>
<SMAL>0</SMAL>
<AVER>0</AVER>
<LARG>0</LARG>
<RVPK>1</RVPK>
<PALL>0</PALL>
</row>
</document>
(#1269830@0)
Last Updated: 2003-7-4
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / 请问有没有哪为兄弟知道how to using ASP script to input a XML file into a SQL server table????xml code is inside.. -shinning(dudu); 2003-7-4 {821} (#1269830@0)
    <?xml version="1.0" encoding="en-US" standalone="yes"?>
    <!-- Generated by Softsilver Transformer 2.3 *** UNREGISTERED *** (http://www.softsilver.com) -->
    <document>
    <row>
    <SOURCE>40532</SOURCE>
    <CLIENT>EAST</CLIENT>
    <RECEIPT__NUMBER>14585</RECEIPT__NUMBER>
    <UNITS>60</UNITS>
    <SMAL>0</SMAL>
    <AVER>0</AVER>
    <LARG>0</LARG>
    <RVPK>1</RVPK>
    <PALL>0</PALL>
    </row>
    <row>
    <SOURCE>40532</SOURCE>
    <CLIENT>EAST</CLIENT>
    <RECEIPT__NUMBER>14585</RECEIPT__NUMBER>
    <UNITS>60</UNITS>
    <SMAL>0</SMAL>
    <AVER>0</AVER>
    <LARG>0</LARG>
    <RVPK>1</RVPK>
    <PALL>0</PALL>
    </row>
    </document>
    • up.up... :( -shinning(dudu); 2003-7-4 (#1270496@0)
    • it's easy, -bill_hu(huhu); 2003-7-4 {281} (#1270965@0)
      use asp to create two server objects, first one is for accessing xml date from xml file(server.createobject("microsoft.xmldom")), another one is for accessing database(server.createobject("adodb.connection")), then use xml API to get data from xml file and store it into table.

More Topics

  • Torvalds patch improves Linux performance by 2.6%
  • GitHub Spark
  • 脑洞大开，突发奇想，用力来传播信息
  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论