Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 26023 invoked from network); 16 Sep 2005 02:16:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Sep 2005 02:16:13 -0000 Received: (qmail 94243 invoked by uid 500); 16 Sep 2005 02:16:09 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 94192 invoked by uid 500); 16 Sep 2005 02:16:08 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 94153 invoked by uid 99); 16 Sep 2005 02:16:08 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Sep 2005 19:16:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [62.231.162.41] (HELO ns.nkmk.ru) (62.231.162.41) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Sep 2005 19:16:17 -0700 Received: from ns.nkmk.ru (root@localhost) by ns.nkmk.ru (8.13.4/8.13.4) with SMTP id j8G2HOU3068042 for ; Fri, 16 Sep 2005 10:17:24 +0800 (KRAST) (envelope-from neverov_dg@nkmk.ru) Received: from bsd4.kmk (bsd4.kmk [200.1.1.54]) by ns.nkmk.ru (8.13.4/8.13.4) with ESMTP id j8G2G98Z067989 for ; Fri, 16 Sep 2005 10:17:23 +0800 (KRAST) (envelope-from neverov_dg@nkmk.ru) Received: from bsd4.kmk (root@localhost) by bsd4.kmk (8.12.11/8.12.11) with SMTP id j8G2Eoba045274 for ; Fri, 16 Sep 2005 10:14:50 +0800 (KRAST) (envelope-from neverov_dg@nkmk.ru) Received: from localhost (neveroff.nkmk.ru [10.40.8.178]) by bsd4.kmk (8.12.11/8.12.11) with ESMTP id j8G2Em9C045264 for ; Fri, 16 Sep 2005 10:14:48 +0800 (KRAST) (envelope-from neverov_dg@nkmk.ru) Date: Fri, 16 Sep 2005 10:14:48 +0800 From: =?Windows-1251?B?zeXi5fDu4iDE7Ojy8Ojp?= X-Mailer: The Bat! (v3.0) Professional Reply-To: =?Windows-1251?B?zeXi5fDu4iDE7Ojy8Ojp?= Organization: nkmk X-Priority: 3 (Normal) Message-ID: <16310123705.20050916101448@nkmk.ru> To: =?Windows-1251?B?zeXi5fDu4iDE7Ojy8Ojp?= Subject: Re: order by problem In-Reply-To: <898639728.20050916095745@nkmk.ru> References: <898639728.20050916095745@nkmk.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=Windows-1251 Content-Transfer-Encoding: 8bit X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on ns.nkmk.ru X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.2/RELEASE, bases: 16092005 #140463, status: clean X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No, score=-3.6 required=5.4 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.0.4 X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, ��. Sorry, it use another SqlMap File, I change it and all is OK. --------------------------------- You wrote 16 �� 2005 �., 9:57:45: > Hi, > I have sqlMap: > > "http://www.ibatis.com/dtd/sql-map-2.dtd"> > > type="nkmk.ibatis.domain.ElementInGost"/> > > > > > > > property="intervalList" > select="elementInGost.getIntervalsOfElement"/> > > parameterClass="ElementInGost" > resultMap="elementInGost.ElementWithIntervals"> > select distinct t1.id_elem, > t1.id_gost, > t2.sname, > t2.lname > from sp_gost_detail t1, sp_name_nsi t2 > where t2.id = t1.id_elem > and t1.id_elem=#elementId# > and t1.id_gost=#gostId# > > > select t2.id intervalId, > t1.kf kf, > t2.conc_ot concOt, > t2.conc_do concDo > from sp_gost_detail t1, sp_interval t2 > where t2.id=t1.id_interval(+) > and t1.id_elem(+)=#elementId# > and t1.id_gost(+)=#gostId# > order by t2.id > > > ElementInGostSqlMapDao: > .... > public ElementInGost getElementById(int gostId, int elementId) > { > ElementInGost elem = new ElementInGost(); > elem.setGostId(new Integer(gostId)); > elem.setElementId(new Integer(elementId)); > return (ElementInGost) > queryForObject("elementInGost.searchElementInGost", elem); > } > ... > Then I have Element object and call element.getIntervalList(), which > return List using "getIntervalsOfElement" from sqlMap file. And > this List is always order by kf field. Why? I change "order by > t2.id" to, for example, "order by t1.kf desc" but there's no changes. > Why?? --------------------------------- -- �� mailto:neverov_dg@nkmk.ru