Hi peter
Thanks for help.
but is it possible with this querry
SELECT c.EDITION,c.PUBLICATIONDATE,d.NAME,d.SHIPPINGNOTES,d.PUBLISHINGIDENTIFIERCODE,d.RETAILPRICE,e.NAME,g.LASTNAME,h.NAME
FROM KEYWORD a,PRODUCTKEYWORDREL b,BOOK c,PRODUCT d,FORMAT e,AUTHORPRODUCTREL f,AUTHOR g,PUBLISHER h
WHERE a.keyword LIKE '%java%'
and a.keywordid=b.keywordid
and b.productid=c.productid
and b.productid=d.productid
and d.formatid=e.formatid
and b.productid=f.productid
and f.authorid=g.authorid
and c.publisherid=h.publisherid
can i use u r funda here .
please help me out .
Ihope so
Thanks once again
pavithra
Originally posted by pavi kavi:
Hi
I need to retrive only 20 datas everytime whenever i execute a querry even though the result set may contain 100 of rows i wnated this dynamically to happen.
For Example when i press the NEXT button it should take only from 21-40 & display it is it possible in EJB.
If YES please tell me how in EJB.
I am using JOIN statement
pavithra