repr�sentation XML de requ�tes SQL

Article View: fr.comp.text.xml

Article #9518

#9518

From: St�phane Lauri�re
Date: Wed, 28 Mar 2001 11:44

39 lines
1959 bytes

Bonjour,
Je recherche un mode de repr�sentation XML de n'importe quelle requ�te SQL.
Savez-vous s'il existe des standards l�-dessus, des propositions?

Exemple :

SELECT FIRST_NAME, LAST_NAME, CREDITOR, BALANCE
   FROM CREDITORS C, DEBTORS D, DEBTS B
 WHERE (C.CREDITOR_ID = B.CREDITOR_ID
       AND D.DEBTOR_ID = B.DEBTOR_ID)

repr�sent� par:

<?xml version="1.0"?>
<QUERY NAME="MYQUERY" TYPE="SELECT" TOP="50">
  <FIELD NAME="FIRST_NAME" />
  <FIELD NAME="LAST_NAME" />
  <FIELD NAME="CREDITORS" />
  <FIELD NAME="BALANCE" />
  <TABLE NAME="CREDITS" ALIAS="A" />
  <TABLE NAME"DEBTORS" ALIAS="D" />
  <TABLE NAME"DEBTS" ALIAS="D" />
  <CRITERIA>
  <OPERATOR ID="OR" >
    <OPERATOR ID="AND">
     <CONDITION VALUE="C.CREDITOR_ID = B.CREDITOR_ID" />
     <CONDITION VALUE="D.DEBTOR_ID = B.DEBTOR_ID" />
    </OPERATOR>
</OPERATOR>

  </CRITERIA>

  <GROUP BY="CEDITORS" />
  <ORDER BY="CREDITOR" />

</QUERY>

Merci.
St�phane

Technical Details

Message-ID: <99sit5$spg$1@reader1.imaginet.fr>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!skynet.be!fr.clara.net!heighliner.fr.clara.net!fr.colt.net!writer!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: FRENCH,ASCII
X-Google-Thread: 114f60,ab156ff9324a78d5,start
X-Google-Attributes: gid114f60,public
X-Google-ArrivalTime: 2001-03-28 03:54:00 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!skynet.be!fr.clara.net!heighliner.fr.clara.net!fr.colt.net!writer!not-for-mail
From: "St�phane Lauri�re" <slauriere@logmetrix.com>
Newsgroups: fr.comp.text.xml
Subject: repr�sentation XML de requ�tes SQL
Date: Wed, 28 Mar 2001 13:44:30 +0200
Organization: ImagiNET / Colt Internet
Lines: 42
Message-ID: <99sit5$spg$1@reader1.imaginet.fr>
NNTP-Posting-Host: access-105.101.rev.fr.colt.net
X-Trace: reader1.imaginet.fr 985779941 29488 213.41.101.105 (28 Mar 2001 11:45:41 GMT)
X-Complaints-To: abuse@imaginet.fr
NNTP-Posting-Date: 28 Mar 2001 11:45:41 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400