Return-Path: Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-dev@xml.apache.org Delivered-To: moderator for cocoon-dev@xml.apache.org Received: (qmail 97018 invoked from network); 28 Sep 2000 18:28:07 -0000 Received: from unknown (HELO north49design.com) (qmailr@216.18.48.247) by locus.apache.org with SMTP; 28 Sep 2000 18:28:07 -0000 Received: (qmail 28394 invoked from network); 28 Sep 2000 18:25:19 -0000 Received: from cr505198-a.yec1.on.wave.home.com (HELO investorthink.com) (24.43.1.27) by 216.18.48.247 with SMTP; 28 Sep 2000 18:25:19 -0000 Message-ID: <39D38D89.5BA2FB8B@investorthink.com> Date: Thu, 28 Sep 2000 14:27:21 -0400 From: Michael Glenn Organization: InvestorThink X-Mailer: Mozilla 4.7 [en] (Win98; U) X-Accept-Language: en,pdf MIME-Version: 1.0 To: cocoon-dev@xml.apache.org Subject: Re: [C1.8.1-dev] esql.xsl References: <003601c0296a$649480e0$0a01a8c0@parkwardcars.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N > OD wrote: > > Any interest in some new tags for the esql.xsl logicsheet that > automatically generate parts of a GUI? > I wouldn't incorporate that into the SQL taglib but instead build it into a process by which variables (start and end) are passed along (via get or post) stipulating how many records to display at one time. The "prev" and "next" tags re-run the query but specify the new data range. More elegant and it separates logic from design. Use LIMIT to specify record start and end points. This would take the overhead off xslt processing if unwanted records were eliminated in advance, especially for large result sets. I don't know if all databases support this but I believe it's SQL92. Don't forget ORDER BY to reduce unpredictable results when unsorted. -- Michael Glenn, http://www.mglenn.com Chief Technology Officer Investorthink http://www.investorthink.com 416.544.9904 -----BEGIN PGP PUBLIC KEY BLOCK----- Version: PGPfreeware 6.5.2 for non-commercial use mQGiBDi1W3gRBADgkh1Qvms9Qz1zpStGDdSs36K0KGX8mhuXMn21C6cE9DQ4V6d7 S8yQo+fFwos0lV+iIy0vWomq2LI1tiniV46v8cn7OyM0QI2c4IVgNn7h5hwq8Yue RmdSk9Nc1B8FJjWXZKkAxrZ9UtBRpl1USUnh8NnN0uQ+4pB9QoRK77OFnQCg/8hh KqMCe7y3FF5jHtSK/pHT308D/ifQNxg97Sp1BQxrOGA07Jj4MbWwZDUZH3h0loSJ TmqEZU8dykPFu3+MCgiUP6en2b5Qk0r/ayHiS7cOwCMUnsmI2Ys4TC36w2CXIhUh yt8xWqR8uGJDw3OsRr4bOgOm2rhcBtsCx4CSCZ80ysWcDT2KERg4l9kgP1poI27x l38MA/9cJiLDhT84+ktmTpwkzDIbBWqBEa9avd28fMLjziJMw6Ak2a5B3lONDBWD ymd0UHjuuHm3aXDA2xAiZtQRvYpEFKsIOoL6+eMjkDC2VfEjoYOACqSlPxO5lxb4 oINcoxBWHjPMWIjS29LydC+OyVZW0RfCqLyANEZFqZT0lkJPI7QfTWljaGFlbCBH bGVubiA8bWlrZUBtZ2xlbm4uY29tPokATgQQEQIADgUCOLVbeAQLAwIBAhkBAAoJ EG/6eNodQfh3VAQAoOiLvTGsq59pmWUh9XdjjU4SS3aUAJ4ywgkjUkmUJ5ImThp2 3k1rEax3i7kCDQQ4tVt4EAgA9kJXtwh/CBdyorrWqULzBej5UxE5T7bxbrlLOCDa AadWoxTpj0BV89AHxstDqZSt90xkhkn4DIO9ZekX1KHTUPj1WV/cdlJPPT2N286Z 4VeSWc39uK50T8X8dryDxUcwYc58yWb/Ffm7/ZFexwGq01uejaClcjrUGvC/RgBY K+X0iP1YTknbzSC0neSRBzZrM2w4DUUdD3yIsxx8Wy2O9vPJI8BD8KVbGI2Ou1WM uF040zT9fBdXQ6MdGGzeMyEstSr/POGxKUAYEY18hKcKctaGxAMZyAcpesqVDNmW n6vQClCbAkbTCD1mpF1Bn5x8vYlLIhkmuquiXsNV6TILOwACAgf9H57D7zhr/7t6 IxbxBMCFy4EHkD5awkfpxSjv0kLV4AQsXfdk1LsEJLFp8WLquo2ftPpSsMR2vYMa qtyK6FB9I+wq8h76m2RsHoAYVeXYpxckbXtNstz/9qENctdYn2f190v46FCxun3c IghoP4rBnJQNOQIcSQWSEWyOfFjCSlEv/7RSS3cL19r7OE0m7yJprBvAmav+TuHM UmG4Etdi89VEiMYXeFV08CmT12xt+Lel7/YpDlcFBQEjy810nb19w2HCOxh/JMEO C5gXXKMMgtWUTfY/gw9oZOXSy5EffcLjk4jJ2J3FJSwqhOQgBKi0l8I4r1QMmOdE 9WPpnDrHrYkARgQYEQIABgUCOLVbeAAKCRBv+njaHUH4d547AJ9ze+4zXlsv/NdX GhsLTWp+BOQEvACgqEN5l2RiBVEYJDx1ktz9cSuvcrI= =KXHB -----END PGP PUBLIC KEY BLOCK-----