On 9/28/05, Zsolt <[EMAIL PROTECTED]> wrote: > Hi Varun, > > right now we provide (self made links) where we assign an "ORDER BY" to the > link. Now we want to switch to displaytag but would like still sort using > the database because we can say: ORDER BY UPPER(name) ASC, UPPER(address) > DESC (just an example). > > How can I do it with displaytag? >
Seems that you haven't seen this page. http://displaytag.sourceforge.net/11/tut_externalSortAndPage.html > Zsolt > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:displaytag-user- > >[EMAIL PROTECTED] On Behalf Of Varun Mehta > >Sent: Wednesday, September 28, 2005 12:47 PM > >To: [email protected] > >Subject: RE: [displaytag-user] Large data set treatment by the database > > > >Hi Zsolt, > > > >DB sorting is better, but if you wish to change your sorting parameters at > >run time and allow other options, you'll mostly write a stored proc, that > >reduces portability across DB. If that ain't your concern, then its better, > >else you can go for the default sorting mechanism, and then rearrange the > >list using display-tags as and when required. > > > >DB sorting reduces your headache for sorting at the front end. > > > >I've not developed anything in specific for [display-tags + active widgets] > >as yet, just working on it, and checking if it's possible to do the same. > >Have other things in pipeline also, so a bit slow with the same. > > > >Regards > >Varun Mehta > >Phone: (020) 3023 4656 > >Websites: > >* http://varun.cjb.net [HTML] > >* http://varuninfo.cjb.net [Blogged] > >* http://varunmehta.cjb.net [Flash] > > > >*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > >imagination is more important than knowledge - albert einstein > >*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > > > >-----Original Message----- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] On Behalf Of Zsolt > >Sent: Wednesday, September 28, 2005 11:00 AM > >To: [email protected] > >Subject: RE: [displaytag-user] Large data set treatment by the database > > > >Varun, > > > >Can you provide me a build please (I mean executable jars)? > > > >Any list about other new features? Because I have a database in the > >background I would like to delegate all sorting to the database. What is > >the > >best way? > > > >zsolt > > > >>-----Original Message----- > >>From: [EMAIL PROTECTED] [mailto:displaytag-user- > >>[EMAIL PROTECTED] On Behalf Of Thai Dang Vu > >>Sent: Tuesday, September 27, 2005 7:38 PM > >>To: [email protected] > >>Subject: RE: [displaytag-user] Large data set treatment by the database > >> > >>I think you should download the source code from CVS and compile it. I > >>attached my build.xml file to compile it (it won't work on your machine) > >>and you also need to download these libraries: > >> > >>commons-beanutils.jar httpunit.jar junit.jar struts.jar > >>commons-collections-3.1.jar itext-1.3.jar servlet-api.jar webwork- > >>2.1.7.jar > >>commons-lang-2.1.jar jsp-api.jar spring.jar xwork- > >>1.0.5.jar > >>commons-logging.jar jstl.jar standard.jar > >> > >>>>> [EMAIL PROTECTED] 9/27/2005 11:11:14 AM >>> > >>I get an exception: > >> > >>Exception: [.ELTableTag] Invalid value for attribute "sort" > >>value="external" > >>ERROR InsertTag - ServletException in '/bugs/userTrackerItems.jsp': > >>Invalid value for attribute "sort" value="external" > >>javax.servlet.ServletException: Invalid value for attribute "sort" > >>value="external" > >> > >>>-----Original Message----- > >>>From: [EMAIL PROTECTED] [mailto:displaytag- > >user- > >>>[EMAIL PROTECTED] On Behalf Of Thai Dang Vu > >>>Sent: Tuesday, September 27, 2005 2:45 PM > >>>To: [email protected] > >>>Subject: RE: [displaytag-user] Large data set treatment by the database > >>> > >>>Your problems were solved with display tag already. Could you search in > >>the > >>>archive for "external sort" or "partial list"? If you find nothing, I'll > >>>tell you what I did. > >>> > >>>>>> [EMAIL PROTECTED] 9/26/2005 2:57:21 AM >>> > >>>I'm facing the same problem, cos my data runs across pages, there is a > >>nice > >>>javascript available, but I'm looking at the feasibility of clubbing them > >>>together for optimal use... > >>> > >>>http://www.activewidgets.com/grid/ > >>> > >>>Check this might be of use. > >>> > >>>Regards > >>>Varun Mehta > >>>Phone: (020) 3023 4656 > >>>Websites: > >>>* http://varun.cjb.net [HTML] > >>>* http://varuninfo.cjb.net [Blogged] > >>>* http://varunmehta.cjb.net [Flash] > >>> > >>>*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > >>>imagination is more important than knowledge - albert einstein > >>>*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > >>> > >>>-----Original Message----- > >>>From: [EMAIL PROTECTED] > >>>[mailto:[EMAIL PROTECTED] On Behalf Of Nicolas > >>>Clemeur > >>>Sent: Monday, September 26, 2005 12:14 PM > >>>To: [email protected] > >>>Subject: [displaytag-user] Large data set treatment by the database > >>> > >>>Hello everyone, > >>> > >>>I have just discovered the displaytag library and it looks really good. I > >>>am > >>>investigating how I can use it in my current projects and I came across > >>>some > >>>questions. I have tried to look in the archive but, could not really find > >>>any answers. Sorry if this information is availabel somewhere else. > >>> > >>>The data I am displaying are coming from a database and can contain a > >>large > >>>number of rows. So we are not retrieving all the rows every time a page a > >>>is > >>>displayed which would be too expensive for the web server. We are > >>>retrieving > >>>rows 1 to 20 for page 1, 21 to 40 for page 2, etc... > >>> > >>>This approach looks unfortunatelly incompatible with the sorting/paging > >>>functionnality of displaytag. The only way I can see to solve this > >problem > >>>is to have more flexibility in the way the sorting/paging are working. > >>> > >>>For example, it would be nice to be able to specify in the > ><display:table> > >>>attributes the name of a parameter that would containt the page number > >>that > >>>should be retrieved from the database (I think this is probably already > >>>feasible by customising the links that are created for the navigation). > >>No, > >>>the only piece missing here, is that the application should be abble > >>>provide > >>>to the tag the total number of rows that is in this dataset so that > >>>displaytag can build the navigation links. I don't think that this is > >>>possible currently? > >>> > >>>What about something like a PageNavigationDecorator that would extend the > >>>default implementation. > >>> > >>>For sorting, I have the same problem. Since I am not retrieving all the > >>>rows, I need to do the sorting in the database it-self (which is much > >more > >>>efficient anyway), so again, it would be nice to be abble to specify the > >>>name of parameters where the webapp should look at for the column to sort > >>>as > >>>well as the order to sort. > >>> > >>>Maybe the easiest and more flexible way to achieve this is to have the > >>>possibility to define the <th> with an additional tag <table:header> > >>nested > >>>inside <table:column> so that we can completely customise the <th> tag if > >>>necessary. > >>> > >>>In the same way, it would be nice if we could add javascript event > >handler > >>>to the headers or cells separately... > >>> > >>>Cheers > >>> > >>>Nicolas > >>> > >>> > >>> > >>> > >>>------------------------------------------------------- > >>>SF.Net email is sponsored by: > >>>Tame your development challenges with Apache's Geronimo App Server. > >>>Download > >>>it for free - -and be entered to win a 42" plasma tv or your very own > >>>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > >>>_______________________________________________ > >>>displaytag-user mailing list > >>>[email protected] > >>>https://lists.sourceforge.net/lists/listinfo/displaytag-user > >>> > >>> > >>> > >>>------------------------------------------------------- > >>>SF.Net email is sponsored by: > >>>Tame your development challenges with Apache's Geronimo App Server. > >>>Download > >>>it for free - -and be entered to win a 42" plasma tv or your very own > >>>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > >>>_______________________________________________ > >>>displaytag-user mailing list > >>>[email protected] > >>>https://lists.sourceforge.net/lists/listinfo/displaytag-user > >>> > >>> > >>>------------------------------------------------------- > >>>SF.Net email is sponsored by: > >>>Tame your development challenges with Apache's Geronimo App Server. > >>>Download > >>>it for free - -and be entered to win a 42" plasma tv or your very own > >>>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > >>>_______________________________________________ > >>>displaytag-user mailing list > >>>[email protected] > >>>https://lists.sourceforge.net/lists/listinfo/displaytag-user > >> > >> > >> > >>------------------------------------------------------- > >>SF.Net email is sponsored by: > >>Tame your development challenges with Apache's Geronimo App Server. > >>Download > >>it for free - -and be entered to win a 42" plasma tv or your very own > >>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > >>_______________________________________________ > >>displaytag-user mailing list > >>[email protected] > >>https://lists.sourceforge.net/lists/listinfo/displaytag-user > >> > >> > >>------------------------------------------------------- > >>This SF.Net email is sponsored by: > >>Power Architecture Resource Center: Free content, downloads, discussions, > >>and more. http://solutions.newsforge.com/ibmarch.tmpl > >>_______________________________________________ > >>displaytag-user mailing list > >>[email protected] > >>https://lists.sourceforge.net/lists/listinfo/displaytag-user > > > > > > > >------------------------------------------------------- > >This SF.Net email is sponsored by: > >Power Architecture Resource Center: Free content, downloads, discussions, > >and more. http://solutions.newsforge.com/ibmarch.tmpl > >_______________________________________________ > >displaytag-user mailing list > >[email protected] > >https://lists.sourceforge.net/lists/listinfo/displaytag-user > > > > > > > >------------------------------------------------------- > >This SF.Net email is sponsored by: > >Power Architecture Resource Center: Free content, downloads, discussions, > >and more. http://solutions.newsforge.com/ibmarch.tmpl > >_______________________________________________ > >displaytag-user mailing list > >[email protected] > >https://lists.sourceforge.net/lists/listinfo/displaytag-user > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Power Architecture Resource Center: Free content, downloads, discussions, > and more. http://solutions.newsforge.com/ibmarch.tmpl > _______________________________________________ > displaytag-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/displaytag-user > -- rgds Anto Paul ------------------------------------------------------- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl _______________________________________________ displaytag-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/displaytag-user
