XML & Databases
smuench at us.oracle.com
Tue Jan 18 18:04:25 GMT 2000
Have a look at the "Airport Code Validation" at:
This works with an IE5 browser to show how a client
HTML page can use a server-side XML Data "Service"
(in this example, provided server-side by an Oracle
XSQL-Page with a query over an AIRPORTS table
containing all the known world airports) to
help the user do data-entry.
In this demo, if the three-letter code you type in
matches one in the database, it fills in the info
that it gets back in the XML Datagram from the server.
If the code you type in (e.g. "VENI") does not
exactly match a 3-letter code, it falls back and
does a fuzzy-match query in the server and
returns an XML datagram with a list of potential
airports matching the name ("Venice, Italy", etc.)
which the DHTML page uses to build up a dynamic
poplist for the user to pick from.
Steve Muench, Consulting Product Manager & XML Evangelist
Business Components for Java Development Team
----- Original Message -----
From: "Brandt Dainow" <bd at internet-etc.com>
To: "'LaShika M'" <archiver at db.geocrawler.com>; <xml-dev at ic.ac.uk>
Sent: Tuesday, January 18, 2000 8:36 AM
Subject: RE: XML & Databases
| YEs - I've seen this demo'd, extracting from Oracle as XML to an XML
| memory-resident XML object. The XSL then transforms the XML into an SMTP
| unless you want to display in a web page. You're better off using XSL to
| transform the source XML output into the appropriate format for your
| destination database. XSL is easier to use and less bug-ridden than
| around & works (sorta). It only requires a couple of lines of code in
| on our website at http://www.internet-etc.com/courses/xml/xsl/xslfset.htm.
| Brandt Dainow
| bd at internet-etc.com
| Internet Etc Ltd
| >-----Original Message-----
| >From: owner-xml-dev at ic.ac.uk [mailto:owner-xml-dev at ic.ac.uk]On
| >Behalf Of
| >LaShika M
| >Sent: Wednesday, January 12, 2000 4:04 AM
| >To: xml-dev at ic.ac.uk
| >Subject: XML & Databases
| >This message was sent from Geocrawler.com by "LaShika M"
| ><lmcclu1 at hallmark.com>
| >Be sure to reply to that address.
| >Is it possible to extract data out of a database and format in
| >Is this a crazy thought? I have only been looking at XML for
| >a couple of days and I have a
| >assignment quickly approaching need a High Level Explantion of
| >if it is possible to extract info
| >out of one database, put in XML format, transfer to another
| >database. HELP!
| >Geocrawler.com - The Knowledge Archive
| >xml-dev: A list for W3C XML Developers. To post,
| >mailto:xml-dev at ic.ac.uk
| >Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ or
| >CD-ROM/ISBN 981-02-3594-1
| >Please note: New list subscriptions now closed in preparation
| >for transfer to OASIS.
| xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
| Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ or CD-ROM/ISBN
| Please note: New list subscriptions now closed in preparation for transfer
xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ or CD-ROM/ISBN 981-02-3594-1
Please note: New list subscriptions now closed in preparation for transfer to OASIS.
More information about the Xml-dev