Office中国论坛/Access中国论坛

标题: MSXML還不完善,問題太多! [打印本页]

作者: HG    时间: 2002-10-20 00:53
标题: MSXML還不完善,問題太多!
在SQL2k中新加入了對XML支持,但還不完善,且問題同多發,誰有經驗拿出來大家一起分享。
作者: HG    时间: 2002-10-21 21:48
<? xml version ="1.0">
<root xmlns="usr:schemas-microsoft-com:xml-sql"
      xmlns:dt="urn:schemas-microsoft-com:xml-dataypes"
      xmlns:sql="urn:schemas-microsoft-com:xml-sql">
      
  <Schema name = "schema"
  sql:id="inlineschema"
  sql:is-mapping-schems="1">
  
  <ElementType name ="wage" sql:relation="wage" content="empty" model="closed">
   <AttributeType name ="year"  dt:type ="i2"/>
   <AttributeType name ="month" dt:type ="ui1"/>
   <AttributeType name ="empsn" dt:type ="i2"/>
   <AttributeType name ="wage"  dt:type ="fixed.14.4"/>
   <attribute type ="year" sql:field="wage_date_year"/>
   <attribute type ="month" sql:field="wage_date_month"/>
   <attribute type ="empsn" sql:field="wage_date_month"/>
   <attribute type ="wage" sql:field="wage_sum"/>   
  </ElementType>
</Schema>

<sql:xpath-query mapping-schema="#inlineschema">
  orders
</sql:xpath-query>
</root>
----------------------------------------------------------
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------
這是結果,錯從何來。
Please try the following:
Open the 192.168.1.222 home page, and then look for links to the information you want.
Click the  Refresh button, or try again later.

Click  Search to look for information on the Internet.
You can also see a list of related sites.




HTTP 500 - Internal server error
Internet Explorer  

作者: hg    时间: 2002-10-21 22:12
- <root xmlns="usr:schemas-microsoft-com:xml-sql" xmlns:dt="urn:schemas-microsoft-com:xml-dataypes" xmlns:sql="urn:schemas-microsoft-com:xml-sql">
- <Schema name="schema" sql:id="inlineschema" sql:is-mapping-schems="1">
- <ElementType name="wage" sql:relation="wage" content="empty" model="closed">
  <AttributeType name="year" dt:type="i2" />
  <AttributeType name="month" dt:type="ui1" />
  <AttributeType name="empsn" dt:type="i2" />
  <AttributeType name="wage" dt:type="fixed.14.4" />
  <attribute type="year" sql:field="wage_date_year" />
  <attribute type="month" sql:field="wage_date_month" />
  <attribute type="empsn" sql:field="wage_date_month" />
  <attribute type="wage" sql:field="wage_sum" />
  </ElementType>
  </Schema>
  <?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="Inline schema '#inlineschema' is missing"?>
  </root>
------------------------------------------------------------
這是什麼錯誤,為什麼會這樣出錯,不明白,高手救我。




欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) Powered by Discuz! X3.3