Re: Pagination query

From: Laszlo Spoor (lspoor_cayenn..otmail.com)
Date: Wed Mar 02 2005 - 13:01:32 EST

  • Next message: Laszlo Spoor: "Re: Pagination query"

    Hi Sami,

    I did not check my mail a couple of days.. Sorry, I have been busy with
    other things.. Are you still having problems and if so, are the java code
    you sent still up to date?

    Laszlo
    >From: "Sami Mohammed" <SMOHAMME..ndependenthealth.com>
    >Reply-To: cayenne-use..bjectstyle.org
    >To: <cayenne-use..bjectstyle.org>
    >Subject: Re: Pagination query
    >Date: Tue, 01 Mar 2005 19:57:40 -0500
    >
    >Hi Joshua,
    >
    >I didnt get anything with those two attributes.
    >
    >thanks
    >sami
    >
    >CONFIDENTIALITY NOTICE. This e-mail and attachments, if any, may contain
    >confidential information which is privileged and protected from disclosure
    >by Federal and State
    >confidentiality laws rules and regulations. This e-mail and attachments,
    >if any, are intended for the designated addressee only. If you are not the
    >designated addressee, you
    >are hereby notified that any disclosure, copying, or distribution of this
    >e-mail and its attachments, if any, may be unlawful and may subject you to
    >legal consequences. If you
    >have received this e-mail and attachments in error, please contact
    >Independent Health immediately at (716) 631-3001 and delete the e-mail and
    >its attachments from your
    >computer. Thank you for your attention
    >
    > >>> joshua.t.pyl..mail.com 03/01/05 06:11PM >>>
    >Sorry Sami but I don't use the logic:iterate tag. I also use struts
    >but I use my own custom tag to render the results of my queries.
    >
    >Here is a link to the Struts documentation that mentions a length and
    >offest attribute...
    >
    >http://struts.apache.org/userGuide/struts-logic.html#iterate
    >
    >My advise is you experiment with those two attributes and see what you get.
    >
    >On Tue, 01 Mar 2005 16:16:48 -0500, Sami Mohammed
    ><SMOHAMME..ndependenthealth.com> wrote:
    > > Hi joshua,
    > >
    > > Thank you.
    > >
    > > I am using struts iterate tag to display.
    > > see the code BELOW:
    > >
    > > <logic:iterate id="display" name="DisplayResult">
    > > <bean:write name="display" property="name"/>
    > > </logic:iterate>
    > >
    > > In action class i Stored the Display object into the request object like
    >this
    > >
    > > request.setAttribute("DisplayResult", cwViewBean);
    > >
    > > anything i have to do with iterate tag to limit the rows, since i
    >already limit the pageSize to 25 in action class.
    > >
    > > if you have any idea pls let me know.
    > >
    > > thanks
    > > sami
    > >
    > > CONFIDENTIALITY NOTICE. This e-mail and attachments, if any, may
    >contain confidential information which is privileged and protected from
    >disclosure by Federal and State
    > > confidentiality laws rules and regulations. This e-mail and
    >attachments, if any, are intended for the designated addressee only. If
    >you are not the designated addressee, you
    > > are hereby notified that any disclosure, copying, or distribution of
    >this e-mail and its attachments, if any, may be unlawful and may subject
    >you to legal consequences. If you
    > > have received this e-mail and attachments in error, please contact
    >Independent Health immediately at (716) 631-3001 and delete the e-mail and
    >its attachments from your
    > > computer. Thank you for your attention
    > >
    > > >>> joshua.t.pyl..mail.com 03/01/05 03:33PM >>>
    > > It might help Sami if you did not comment out the following 2 lines...
    > >
    > > // adding paging functionality
    > > //cwTableParamMap.put(Constants.CW_REQ_PARAM_PAGE_SIZE, new
    >Integer(mPageSize));
    > > //cwTableParamMap.put(Constants.CW_REQ_PARAM_CURRENT_ROW, new
    > > Integer(mCurrentRow));
    > > // adding paging functionality
    > >
    > > I don't know this crosswalk thing but you seem to have commented out
    > > the controls that would limit your paging. The way cayenne does its
    > > paging is that it will only query the data on a per page basis but if
    > > your code loops through all of the data it will retrieve all of the
    > > data.
    > >
    > > It appears that your cntrols to limit the looping of your result list
    > > is not in place.
    > >
    > > Once again I do not know crosswalk so take my answer with that grain of
    >salt.
    > >
    > > On Tue, 1 Mar 2005 13:47:20 -0500 (EST), Andrus Adamchik
    > > <andru..bjectstyle.org> wrote:
    > > > Sami,
    > > >
    > > > I understand that you are stuck at the moment. But please don't repost
    > > > your question over and over again. Somebody (maybe myself) will look
    >at
    > > > it, just give it some time. That's the nature of free support - people
    >are
    > > > willing to give their time to community, but you shouldn't push too
    >hard.
    > > >
    > > > Andrus
    > > >
    > > >
    > > > > HI
    > > > >
    > > > > any body help me .
    > > > > page reterives all the rows from the table.
    > > > > see code below
    > > > >
    > > > >
    >SelectQuery
    > > > > cwDataQuery
    > > > > = new
    > > > > SelectQuery(cwClass);
    > > > >
    >cwDataQuery.addOrderings(cwObject.getViewOrderings());
    > > > > //cwDataQuery.setFetchLimit(100);
    > > > > cwDataQuery.setPageSize(25); //
    >HERE I AM SETTING PAGE SIZE =25
    > > > > BUT STILL ITS RETRIVING ALL THE ROWS FROM THE TABLE WHATS THE
    > > > > PROBLEM
    > > > >
    > > > >
    > > > > // Perform the query
    > > > > List resultList =
    >context.performQuery(cwDataQuery);
    > > > > THANKS
    > > > > SAMI
    > > > >
    > > > >
    > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > > --
    > > Joshua T. Pyle
    > > Go has always existed.
    > >
    > >
    >
    >
    >--
    >Joshua T. Pyle
    >Go has always existed.

    _________________________________________________________________
    Talk with your online friends with MSN Messenger http://messenger.msn.nl/



    This archive was generated by hypermail 2.0.0 : Wed Mar 02 2005 - 13:02:03 EST