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? 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
