XML & Databases

[Steve Muench]

Have a look at the "Airport Code Validation" at:

http://technet.oracle.com/tech/xml/demo/demo1.htm

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.

have fun.

_________________________________________________________
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
Object
| in an IE5 webpage which then uses JavaScript to write XSL into a 2nd
| memory-resident XML object.  The XSL then transforms the XML into an SMTP
| format which JavaScript then back to the server where it is outputted as a
| pager message.  In actual fact, for your purposes JavaScript is overkill
| 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
| JavaScript anyway.  You'll need a processor to support and run XSL, which
| isn't easy to find.  I use JavaScript myself to do this simply because
it's
| around & works (sorta).  It only requires a couple of lines of code in
| JavaScript to do this.  There's a little demo of using XSL with JavaScript
| on our website at http://www.internet-etc.com/courses/xml/xsl/xslfset.htm.
|
| Brandt Dainow
| bd at internet-etc.com
| Internet Etc Ltd
| http://www.internet-etc.com
|
| >-----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
| >XML using Javascript?
| >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
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 981-02-3594-1
Please note: New list subscriptions now closed in preparation for transfer to OASIS.