[From nobody Fri Aug  6 17:08:12 2004
Return-Path: <jmehta@mdnotes.com>
Received: from relay1.firstlink.com ([66.37.143.28])
	by bissell.mail.mindspring.net (Earthlink Mail Service) with ESMTP id
	18jKoK1D83Nl3rE0
	for <servlets@mindspring.com>; Wed, 4 Dec 2002 20:01:50 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
	by relay1.firstlink.com (Postfix) with ESMTP id 0B6CBB5E20
	for <servlets@mindspring.com>; Wed,  4 Dec 2002 18:01:50 -0700 (MST)
Received: from MDN-MAIN.mdnotes.com (MDNotes.com [66.152.221.179])
	by relay1.firstlink.com (Postfix) with ESMTP id B13C2B5E25
	for <jhunter@servlets.com>; Wed,  4 Dec 2002 18:01:43 -0700 (MST)
Subject: ResultSetBuilder class giving xml document in reverse order
Date: Wed, 4 Dec 2002 20:06:19 -0500
Message-ID: <6ED02078F47515408A210DC2124C84D78E9A@MDN-MAIN.mdnotes.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
content-class: urn:content-classes:message
X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
Thread-Topic: ResultSetBuilder class giving xml document in reverse order
Thread-Index: AcKR4xn6DulxbegVQvK8utJ0SfA8HQKFhQFA
From: "Jasmin Mehta" <jmehta@mdnotes.com>
To: "Jason Hunter" <jhunter@servlets.com>
X-Virus-Scanned: by First Link Technology, Inc.
X-Razor-id: 4564c825268b7070ecfb4fc5cefdf910689f5d5e
X-Mozilla-Status2: 00000000

Hi Jason,

I'm getting the resultant XML document in reverse order of the rows I'm
getting in my result set. How can I get the correct order?=20

I've piece of code like below:

StringBuffer sql =3D new StringBuffer();
       sql.append("SELECT * FROM PatientData WHERE (Doc_Code =3D
'"+doccode[0]+"')");
       for (int k =3D 0; k < doccode.length-1; k++)
         sql.append(" OR (Doc_Code =3D '"+doccode[k+1]+"')");
       String sql_1 =3D sql.toString();
       String root =3D "PatientData";
       String row  =3D  "PatientInfo";
       rstoxml =3D new RStoXMLBuilder(conn, sql_1, root, row);
       xmldoc  =3D rstoxml.getJDomObj();
--------------

where RStoXMLBuilder class has below method

public Document getJDomObj() {
 =20
      Document doc =3D null;

       rs =3D stmt.executeQuery(sql);
       ResultSetBuilder builder =3D new ResultSetBuilder(rs);
       builder.setRootName(root); =20
       builder.setRowName(row);

       doc =3D builder.build();

       FileOutputStream out =3D new
FileOutputStream("C:/JRun4/servers/default/MDNotes/secretary/SOAP.xml");
       XMLOutputter outputter =3D new XMLOutputter();
       outputter.output(doc, out);
  =20
    return doc;
}

Here, I can see that SOAP.xml is displaying <patientInfo> nodes in
descending order of what I'm getting rows as a resultset.

Thanks
Jasmin=20
-----Original Message-----
From: Jason Hunter [mailto:jhunter@servlets.com]=20
Sent: Thursday, November 21, 2002 6:46 PM
To: Jasmin Mehta
Subject: Re: ResultSetBuilderDemo.java

The latest code change was minor.  The code will very likely work.  Give
it a shot.

-jh-


]