[jboss-user] [JBoss Seam] - Re: limiting size of query/result set

[pdhaigh]

ah excellent, thanks.

It doesn't really matter, but I noticed that this actually translates to LIMIT <maxResults+1>:

<framework:entity-query
  | 		name="randomPageImagesSmall"
  | 		max-results="3"
  | 	>
  | 		<framework:ejbql>from PageImage</framework:ejbql>
  | 		<framework:order>RAND()</framework:order>
  | 	</framework:entity-query>	

=

order by rand() limit 4

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4091100#4091100

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4091100