Re: Pagination in wicket
Hey Jesse Thanks for the response... it works well - K -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-tp1878842p4666412.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Pagination in wicket
Hey there i have been trying to trying to implement something like (textbox) of (totalnumberofpages) any suggestions on this Thanks in advance... - K -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-tp1878842p4666398.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Pagination in wicket
including nav
and data table
}
}
@Override
protected void onConfigure()
{
super.onConfigure();
setEnabled(dataTable.getCurrentPage()
dataTable.getPageCount() - 1);
}
});
add(new Label(numberOfPages, new AbstractReadOnlyModelLong()
{
@Override
public Long getObject()
{
return dataTable.getPageCount();
}
});
This is bootstrap 3 pretty much does what you are asking. I dont
implement this as a data table toolbar, but rather directly below the
data table (my data table is wrapped in overflow-x: auto).
Cheers,
Jesse
On 27/06/2014 12:58, K wrote:
Hey there
i have been trying to trying to implement something like
(textbox) of (totalnumberofpages)
any suggestions on this
Thanks in advance...
-
K
--
View this message in context:
http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-tp1878842p4666398.html
Sent from the Users forum mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
Re: Pagination in wicket
(dataTable.getCurrentPage()
dataTable.getPageCount() - 1);
}
});
add(new AjaxFallbackLinkVoid(lastPageLink)
{
@Override
public void onClick(AjaxRequestTarget target)
{
setCurrentPage(dataTable.getPageCount() - 1);
if (target != null){
target.add(container); // container including nav
and data table
}
}
@Override
protected void onConfigure()
{
super.onConfigure();
setEnabled(dataTable.getCurrentPage()
dataTable.getPageCount() - 1);
}
});
add(new Label(numberOfPages, new AbstractReadOnlyModelLong()
{
@Override
public Long getObject()
{
return dataTable.getPageCount();
}
});
This is bootstrap 3 pretty much does what you are asking. I dont
implement this as a data table toolbar, but rather directly below the
data table (my data table is wrapped in overflow-x: auto).
Cheers,
Jesse
On 27/06/2014 12:58, K wrote:
Hey there
i have been trying to trying to implement something like
(textbox) of (totalnumberofpages)
any suggestions on this
Thanks in advance...
-
K
--
View this message in context:
http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-tp1878842p4666398.html
Sent from the Users forum mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
Pagination in wicket, DataTable, DataView or DataGrid
Friends, you can do with dataTable pagination, DataView or DataGrid with wicket? -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-DataTable-DataView-or-DataGrid-tp2272370p2272370.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Pagination in wicket, DataTable, DataView or DataGrid
Yes. See DefaultDataTable. On Tue, Jun 29, 2010 at 10:41 AM, adp adp1...@gmail.com wrote: Friends, you can do with dataTable pagination, DataView or DataGrid with wicket? -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-DataTable-DataView-or-DataGrid-tp2272370p2272370.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org -- Jeremy Thomerson http://www.wickettraining.com
Re: Pagination in wicket, DataTable, DataView or DataGrid
friend, I can not see the information you sent me the link does not open. The problem is that I must carry large amounts of data, and I can not do in memory, which is why I must find a way to do pagination with either a DataTable, DataView or DataGrid. Thanks for responding. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-DataTable-DataView-or-DataGrid-tp2272370p2272445.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Pagination in wicket, DataTable, DataView or DataGrid
Thank you for responding, I'm coming to see the link you sent me. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-DataTable-DataView-or-DataGrid-tp2272370p2272428.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Pagination in wicket, DataTable, DataView or DataGrid
There's not a link that I sent you. I meant try using the DefaultDataTable. Look at how it does pagination. On Tue, Jun 29, 2010 at 11:41 AM, adp adp1...@gmail.com wrote: friend, I can not see the information you sent me the link does not open. The problem is that I must carry large amounts of data, and I can not do in memory, which is why I must find a way to do pagination with either a DataTable, DataView or DataGrid. Thanks for responding. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-DataTable-DataView-or-DataGrid-tp2272370p2272445.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org -- Jeremy Thomerson http://www.wickettraining.com
Re: Pagination in wicket, DataTable, DataView or DataGrid
You are right, sorry, thanks. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Pagination-in-wicket-DataTable-DataView-or-DataGrid-tp2272370p2272561.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Pagination in wicket
Hi I worked on wicket for a month only, i want pagination to be done in wicket. Can anybody guide me or provide some samples, it would be big help for me. I have tried googling Pagination in wicket but not yet get the solution. I have also tried Pagenavigator but don't know how to use it correctly(Stuck in creating the dataview Thanks in advance Karthic -- View this message in context: http://www.nabble.com/Pagination-in-wicket-tp21620591p21620591.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Pagination in wicket
Check out the wicket examples (especially those on repeaters on http://www.wicketstuff.org/wicket13/repeater/) - they'll help you getting started regards, Michael PSkarthic wrote: Hi I worked on wicket for a month only, i want pagination to be done in wicket. Can anybody guide me or provide some samples, it would be big help for me. I have tried googling Pagination in wicket but not yet get the solution. I have also tried Pagenavigator but don't know how to use it correctly(Stuck in creating the dataview Thanks in advance Karthic - Michael Sparer http://talk-on-tech.blogspot.com -- View this message in context: http://www.nabble.com/Pagination-in-wicket-tp21620591p21620701.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Pagination in wicket
You can also check out this wiki page: http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html Basically the DefaultDatatable takes: 1. an array of TableColumn extending classes that are used to build the cell component and connect the row object (typically each column would be connected to a field in the row object). 2. an IDataProvider implementation which provides the table row data. Within it you provide the total number of elements/rows and an iterator containg a specific page. 3. the number of rows per page. The DefaultDataTable has built in support for pagination (i.e. it adds in a set of default top and bottom toolbars) If you look in the constructor you can see what I mean. The last example in the wicketstuff.org example Michael referenced shows what this looks like. Regards, Mike Check out the wicket examples (especially those on repeaters on http://www.wicketstuff.org/wicket13/repeater/) - they'll help you getting started regards, Michael PSkarthic wrote: Hi I worked on wicket for a month only, i want pagination to be done in wicket. Can anybody guide me or provide some samples, it would be big help for me. I have tried googling Pagination in wicket but not yet get the solution. I have also tried Pagenavigator but don't know how to use it correctly(Stuck in creating the dataview Thanks in advance Karthic - Michael Sparer http://talk-on-tech.blogspot.com - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
RE: Problem with Pagination in Wicket 1.3.4
Here is the related Code for the Navigation Panel .
HTML CODE:
span wicket:id=navigator[dataview navigator]/span
JAVA CODE:
PagingNavigator navigator;
navigator = new PagingNavigator(navigator,myDataView)
{
protected void onBeforeRender() {
super.onBeforeRender();
if(pageSize myDataView.getRowCount()){
System.out.println(INSIDE
DATAVIEW Model changed === true);
navigator.setVisible(true);
}
else
{
navigator.setVisible(false);
System.out.println(INSIDE
DATAVIEW Model changed === false);
}
}
};
navigator.setVisible(false);
System.out.println(INSIDE DATAVIEW
CONSTRUTOR=== false);
if(pageSize myDataView.getRowCount()){
System.out.println(INSIDE DATAVIEW
CONSTRUTOR=== true);
navigator.setVisible(true);
}
add(navigator);
Thanks and regards,
Umesh Paliwal
-Original Message-
From: Eric Velazquez [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2008 10:32 PM
To: users@wicket.apache.org
Subject: Re: Problem with Pagination in Wicket 1.3.4
Until 1.3.3 the PagingNavigator class added the navigation links on the
constructor, but on 1.3.4 those links are added on the onBeforeRender
method. Are you overriding the method? would be useful if you provide us
with some related piece of code.
Umesh Paliwal wrote:
Hi ,
I had downloaded Wicket 1.3.4 for the Autocomplete issue with IE.
Now the AutoComplete works fine. But when I click on the table with
Pagination, I get the following error.
Unexpected RuntimeException
WicketMessage: Unable to find component with id 'first' in
[MarkupContainer [Component id = navigator, page =
com.osi.nx.objeditor.ClassBuilder, path =
0:classattrpanel:panel:navigator.DataViewClassTable$3, isVisible =
true,
isVersioned = false]]. This means that you declared wicket:id=first in
your markup, but that you either did not add the component to your
page
at all, or that the hierarchy does not match.
[markup =
jar:file:/C:/Documents%20and%20Settings/uxp1/.m2/repository/org/apache/w
icket/wicket/1.3.4/wicket-1.3.4.jar!/org/apache/wicket/markup/html/navig
ation/paging/PagingNavigator.html
!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed
with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version
2.0
(the License); you may not use this file except in compliance
with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an AS IS BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
implied.
See the License for the specific language governing permissions and
limitations under the License.
--
html xmlns:wicket
body
wicket:panel
lt;lt; nbsp; lt;
# 5
gt; nbsp; gt;gt;
/wicket:panel
/body
/html
, index = 3, current = ' ' (line 21, column 2)]
Root cause:
org.apache.wicket.markup.MarkupException: Unable to find component
with
id 'first' in [MarkupContainer [Component id = navigator, page =
com.osi.nx.objeditor.ClassBuilder, path =
0:classattrpanel:panel:navigator.DataViewClassTable$3, isVisible =
true,
isVersioned = false]]. This means that you declared wicket:id=first in
your markup, but that you either did not add the component to your
page
at all, or that the hierarchy does not match.
[markup =
jar:file:/C:/Documents%20and%20Settings/uxp1/.m2/repository/org/apache/w
icket/wicket/1.3.4/wicket-1.3.4.jar!/org/apache/wicket/markup/html/navig
ation/paging/PagingNavigator.html
!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed
with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version
2.0
(the License); you may not use this file except in compliance
with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License
Re: Problem with Pagination in Wicket 1.3.4
(MarkupContainer.java:1411) at org.apache.wicket.Component.render(Component.java:2318) at org.apache.wicket.Component.renderComponent(Component.java:2421) at org.apache.wicket.ajax.AjaxRequestTarget.respondComponent(AjaxRequestTar get.java:752) at org.apache.wicket.ajax.AjaxRequestTarget.respondComponents(AjaxRequestTa rget.java:649) at org.apache.wicket.ajax.AjaxRequestTarget.respond(AjaxRequestTarget.java: 564) at org.apache.wicket.request.AbstractRequestCycleProcessor.respond(Abstract RequestCycleProcessor.java:104) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java :1177) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1248) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1349) at org.apache.wicket.RequestCycle.request(RequestCycle.java:493) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:387 ) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java: 199) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHan dler.java:1084) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:2 16) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandler Collection.java:206) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.jav a:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConne ction.java:829) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java: 395) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java :488) Markup The problem is in jar:file:/C:/Documents%20and%20Settings/uxp1/.m2/repository/org/apache/ wicket/wicket/1.3.4/wicket-1.3.4.jar!/org/apache/wicket/markup/html/navi gation/paging/PagingNavigator.html: !-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the License); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. -- html xmlns:wicket body wicket:panel lt;lt; nbsp; lt; # 5 gt; nbsp; gt;gt; /wicket:panel /body /html display page view http://localhost:8080/ClassBuilderProto/?wicket:interface=:1:displayPag eViewLink::ILinkListener:: Could you please help me out. Thanks and regards, Umesh Paliwal -- View this message in context: http://www.nabble.com/Problem-with-Pagination-in-Wicket-1.3.4-tp18272116p18283166.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Problem with Pagination in Wicket 1.3.4
Hi , I had downloaded Wicket 1.3.4 for the Autocomplete issue with IE. Now the AutoComplete works fine. But when I click on the table with Pagination, I get the following error. Unexpected RuntimeException WicketMessage: Unable to find component with id 'first' in [MarkupContainer [Component id = navigator, page = com.osi.nx.objeditor.ClassBuilder, path = 0:classattrpanel:panel:navigator.DataViewClassTable$3, isVisible = true, isVersioned = false]]. This means that you declared wicket:id=first in your markup, but that you either did not add the component to your page at all, or that the hierarchy does not match. [markup = jar:file:/C:/Documents%20and%20Settings/uxp1/.m2/repository/org/apache/w icket/wicket/1.3.4/wicket-1.3.4.jar!/org/apache/wicket/markup/html/navig ation/paging/PagingNavigator.html !-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the License); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. -- html xmlns:wicket body wicket:panel a wicket:id=firstlt;lt;/anbsp;a wicket:id=prevlt;/a span wicket:id=navigation a href=# wicket:id=pageLinkspan wicket:id=pageNumber5/span/a /span a wicket:id=nextgt;/anbsp;a wicket:id=lastgt;gt;/a /wicket:panel /body /html , index = 3, current = 'a wicket:id=first' (line 21, column 2)] Root cause: org.apache.wicket.markup.MarkupException: Unable to find component with id 'first' in [MarkupContainer [Component id = navigator, page = com.osi.nx.objeditor.ClassBuilder, path = 0:classattrpanel:panel:navigator.DataViewClassTable$3, isVisible = true, isVersioned = false]]. This means that you declared wicket:id=first in your markup, but that you either did not add the component to your page at all, or that the hierarchy does not match. [markup = jar:file:/C:/Documents%20and%20Settings/uxp1/.m2/repository/org/apache/w icket/wicket/1.3.4/wicket-1.3.4.jar!/org/apache/wicket/markup/html/navig ation/paging/PagingNavigator.html !-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the License); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. -- html xmlns:wicket body wicket:panel a wicket:id=firstlt;lt;/anbsp;a wicket:id=prevlt;/a span wicket:id=navigation a href=# wicket:id=pageLinkspan wicket:id=pageNumber5/span/a /span a wicket:id=nextgt;/anbsp;a wicket:id=lastgt;gt;/a /wicket:panel /body /html , index = 3, current = 'a wicket:id=first' (line 21, column 2)] at org.apache.wicket.markup.MarkupStream.throwMarkupException(MarkupStream. java:464) at org.apache.wicket.MarkupContainer.renderNext(MarkupContainer.java:1344) at org.apache.wicket.MarkupContainer.renderComponentTagBody(MarkupContainer .java:1476) at org.apache.wicket.MarkupContainer.renderAssociatedMarkup(MarkupContainer .java:639) at org.apache.wicket.markup.html.panel.Panel.onComponentTagBody(Panel.java: 112) at org.apache.wicket.Component.renderComponent(Component.java:2481) at org.apache.wicket.MarkupContainer.onRender(MarkupContainer.java:1411) at org.apache.wicket.Component.render(Component.java:2318) at org.apache.wicket.MarkupContainer.renderNext(MarkupContainer.java:1297) at org.apache.wicket.MarkupContainer.renderComponentTagBody(MarkupContainer .java:1476) at org.apache.wicket.MarkupContainer.renderAssociatedMarkup(MarkupContainer .java:639) at org.apache.wicket.markup.html.panel.Panel.onComponentTagBody(Panel.java: 112) at org.apache.wicket.Component.renderComponent(Component.java:2481) at org.apache.wicket.MarkupContainer.onRender(MarkupContainer.java:1411) at
pagination in Wicket...
I'm using pagination , i want to get records from the next page... how do I query the start and count in mysql can any one help me ... regards Shafi -- View this message in context: http://www.nabble.com/pagination-in-Wicket...-tf4934874.html#a14125319 Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: pagination in Wicket...
urgh, this is not a mysql mailing list. while you guys are just trying
to help, if this becomes a pattern there will be way too much noise on
this already pretty freakin busy list. so please next time please tell
the person to go to the appropriate forum, or in this case simply type
in mysql paginataion into google and press the im feeling lucky
button...
-igor
On Dec 3, 2007 2:42 AM, Roy van Rijn [EMAIL PROTECTED] wrote:
This also works pretty well using Hibernate:
Criteria c = session.createCriteria(...);
c.setFirstResult(start);
c.setMaxResults(length);
But beware with using this. Hibernate has Java-Filters for some cases.
ResultTransformers can't be used in combination with paging. The query
will select the amount you need but the transformers could remove
results from that list.
We've noticed that if you automaticly join tables using the HBM file
(fetch) then Hibernate will remove results too. This is very annoying.
For example:
Table 1:
key - t2key - value
1 1 First entry
2 1 Second entry
3 2 Blabla
4 3 More bla..
Table 2:
key - value
1 Some value
2 Some other value
3 Some third value
If you fetch-join table 1 when you query table 2 and try to collect
the first 3 results hibernate will generate the following SQL:
select * from table2 t2 left join table1 t1 on t2.t2key = t2.key limit 0,2;
What will be retrieved:
1 Some value 1 1 First entry
1 Some value 2 1 Second entry
2 Some other value 3 2 Blabla
Because the first (queried) table has duplicate entries Hibernate will
create the following objects:
table1 object: 1, Some value
with Listtable2 object {1,1,First entry, 2,1,Second entry}
and
table1 object: 2, Some other value
with Listtable2 object {3,2,Bla bla}
Just two results... paging messed up :(
This is my experience with paging and ORM mappers, you have to be very
carefull hehe. If somebody here knows a solution to this problem,
please let me know!
Roy
On 12/3/07, Uwe Schäfer [EMAIL PROTECTED] wrote:
wicketshafi schrieb:
how do I query the start and count in mysql
The LIMIT clause can be used to constrain the number of rows returned
by the SELECT statement. LIMIT takes one or two numeric arguments,
which must both be non-negative integer constants (except when using
prepared statements).
With two arguments, the first argument specifies the offset of the first
row to return, and the second specifies the maximum number of rows to
return. The offset of the initial row is 0 (not 1):
SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15
see http://dev.mysql.com/doc/refman/5.0/en/select.html
--
THOMAS DAILY GmbH
Adlerstraße 19
79098 Freiburg
Deutschland
T + 49 761 3 85 59 0
F + 49 761 3 85 59 550
E [EMAIL PROTECTED]
www.thomas-daily.de
Geschäftsführer/Managing Directors:
Wendy Thomas, Susanne Larbig
Handelsregister Freiburg i.Br., HRB 3947
Registrieren Sie sich unter http://morningnews.thomas-daily.de für die
kostenfreien TD Morning News, eine Auswahl aktueller Themen des Tages
morgens um 9:00 in Ihrer Mailbox.
Hinweis: Der Redaktionsschluss für unsere TD Morning News ist täglich um
8:30 Uhr. Es werden vorrangig Informationen berücksichtigt, die nach
16:00 Uhr des Vortages eingegangen sind. Die Email-Adresse unserer
Redaktion lautet [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
