OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   Re: An example of database query result in XML

[ Lists Home | Date Index | Thread Index ]
  • From: len bullard <cbullard@hiwaay.net>
  • To: Jim Amsden <jamsden@us.ibm.com>
  • Date: Tue, 24 Mar 1998 22:43:20 -0600

Jim Amsden wrote:
>  
> So the result might be something like:
> 
> <!ELEMENT Order EMPTY>
> <!ATTLIST Order
>    OrderID ID #REQUIRED
>    CustomerID IDREF #REQUIRED
>    EmployeeID IDREF #REQUIRED
>    OrderDate CDATA #REQUIRED
>    PurchaseOrderNumber CDATA #REQUIRED
>    ContactFirstName CDATA #IMPLIED
>    ContactLastName CDATA #REQUIRED
>    ShipName CDATA #REQUIRED
>    ShipAddress CDATA #REQUIRED
>    ShipCity CDATA #REQUIRED
>    ShipStateOrProvince CDATA #REQUIRED
>    ShipPostalCode CDATA #REQUIRED
>    ShipCountry CDATA #REQUIRED
>    ShipPhoneNumber CDATA #REQUIRED
>    ShipDate CDATA #REQUIRED
>    ShippingMethodID CDATA #REQUIRED
>    FreightCharge CDATA "2.0000"
>    SalesTaxRate CDATA "0.0
> >
> 
> <Order>
>    OrderID="1"
>    CustomerID="1"
>    EmployeeID="5"
>    OrderDate="1995-02-02 00:00:00"
>  PurchaseOrderNumber="52">
>  ContactFirstName="Jaime"
>  ContactLastName="Yorres"
>  ShipName="Let's Stop N Shop"
>  ShipAddress="87 Polk St.
> Siite 5"
>  ShipCity="San Francisco"
>  ShipStateOrProvince="CA"
>  ShipPostalCode"94117"
>  ShipCountry="USA"
>  ShipPhoneNumber="(415) 555-5938"
>  ShipDate="1995-02-03 00:00:00"
>  ShippingMethodID="1"
>  FreightCharge="2.0000"
>  SalesTaxRate="0.0"
> </Order>

There is a long history of debate on the issue of usings 
attibutes vs elements for describing data in SGML.  
The DTD models frequency and occurrence.  In a 
representation where there are not duplicates 
there is no benefit to modeling frequency and occurrence.
In that case, the better representation is the 
simpler one if the query is simplified by this.

Len Bullard

xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo@ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@ic.ac.uk)





 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS