[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: xml and combo

• From: Ronald Bourret <rpbourret@r...>
• To: Avital Nagar <Avital@c...>
• Date: Tue, 25 Sep 2001 09:36:40 -0700

Why are you using XML/DOM at all? Why not just execute a SQL statement
and read the result set with ODBC/JDBC/etc.? Unless you're sending the
XML across the Web (or something similar), I can't see much reason to
use the XML at all.

Assuming you do have a good reason for using XML/DOM, see section 2 of
the following paper for information about mapping a result set to XML:

   http://www.xml.com/pub/a/2001/05/09/dtdtodbs.html

For Java pseudo-code, see section 2.2 of the following paper (you can
ignore the rest):

   http://www.rpbourret.com/xml/DataTransfer.htm

Finally, SAX would be faster than DOM for this purpose.

-- Ron

> Avital Nagar wrote:
> 
> Hi,
> 
> I have a SQL database. Using XML and DOM I have to populate a combo
> box with the data from the db?s table so that if I add new details to
> the table the combo will also display the new updated details. Can
> someone please help me? thanks

• References:
  • xml and combo
    • From: Avital Nagar <Avital@c...>

• Prev by Date: [ANN] XPath Location Path Evaluator in Java
• Next by Date: Re: XInclude vs SAX vs validation
• Previous by thread: xml and combo
• Next by thread: RE: Debating "civil disobedience" against overly complicated specs
• Index(es):
  • Date
  • Thread