Hi experts
I think I am not setting datascroller/datatable up right since database
access defined in "#{queryBean.targetData}" in dataTable always called
twice to display a page.
Could you advise me how I can avoid it ?
The first database access occurs as soon as the command button is
clicked for submit.
Then I do not know why, but the second database access occurs initiating
the same query subsequently before it displays the page.
Thanks,
yasushi
<h:commandButton value="#{msgs.targetSearch}"
actionListener="#{queryBean.quickSearchAction}">
</h:commandButton>
<t:dataScroller id="scroll_1"
for="tableData"
fastStep="20"
pageCountVar="pageCount"
pageIndexVar="pageIndex"
styleClass="scroller"
paginator="true"
paginatorMaxPages="10"
paginatorTableClass="paginator"
paginatorActiveColumnStyle="font-weight:bold;"
actionListener="#{queryBean.scrollerAction}"
>
<t:dataScroller id="scroll_2"
for="tableData"
rowsCountVar="rowsCount"
displayedRowsCountVar="displayedRowsCountVar"
firstRowIndexVar="firstRowIndex"
lastRowIndexVar="lastRowIndex"
pageCountVar="pageCount"
pageIndexVar="pageIndex"
>
<h:outputFormat value="#{msgs['dataScroller_pages']}"
styleClass="standard" >
<f:param value="#{rowsCount}" />
<f:param value="#{displayedRowsCountVar}" />
<f:param value="#{firstRowIndex}" />
<f:param value="#{lastRowIndex}" />
<f:param value="#{pageIndex}" />
<f:param value="#{pageCount}" />
</h:outputFormat>
</t:dataScroller>
<t:dataTable id="tableData"
value="#{queryBean.targetData}"
var="target"
styleClass="targets"
headerClass="queryHeader"
footerClass="queryHeader"
columnClasses="targetId,targetBlast,targetDatabaseRef,
targetFamily,targetNumOfResidues,targetMolWeight,
targetGc,targetPi,targetMemHelix,targetHi,targetSelectDate,
targetStatus,targetCenter,targetRank,targetTier,targetKingdom,targetFamilySize"
rows="20"
preserveDataModel="true"
sortColumn="#{queryBean.sort}"
sortAscending="#{queryBean.ascending}"
preserveSort="true">
