Please remove the state attribute it should be a ref to a SheetState
Instance.
Please remove showRowRage, showDirectLinks and directLinkCount
attributes they make no sense for a dataModel for a resultSet because
the dataModel returns rowCount -1 for a resultSet.
Can you send me the ManagedBean code, please.
Bernd
John schrieb:
That's what I thought - so I changed it to uppercase. Didn't affect the
results.
createTableStatement.execute("CREATE CACHED TABLE quarantine(FILENAME
CHAR(64), SENDER CHAR(128), RECIPIENT CHAR(128), SUBJECT CHAR(128),
FILTEREDBY CHAR(24), MATCHTEXT CHAR(128), CONSTRAINT cQuarPRI PRIMARY
KEY (FILENAME))");
<t:sheet
value="#{quarantine.rslt}"
id="sheet"
columns="3*;1*;3*;3*;3*"
var="quarantineRec"
state="1"
showRowRange="left"
showPageRange="right"
showDirectLinks="center"
pagingLength="7"
directLinkCount="5">
<t:column label="From" id="name" sortable="true">
<t:out value="#{quarantineRec.SENDER}" />
</t:column>
<t:column label="To" id="number" sortable="false"
align="center">
<t:out value="#{quarantineRec.RECIPIENT}" />
</t:column>
<t:column label="Subject" sortable="true">
<t:out value="#{quarantineRec.SUBJECT}" />
</t:column>
<t:column label="Matched" sortable="true">
<t:out value="#{quarantineRecr.MATCHTEXT}" />
</t:column>
<t:column label="Filtered" sortable="true" align="right">
<t:out value="#{quarantineRec.FILTEREDBY}" />
</t:column>
</t:sheet>
-----Original Message-----
From: Bernd Bohmann [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 11:02 AM
To: MyFaces Discussion
Subject: Re: Tobago sheet using jdbc ResultSet example request
John,
please send the sheet jsp and the definition of the table.
Maybe a case-sensitive problem.
Bernd
John schrieb:
Ok.
My bean is retrieving 2 rows, but they are not being displayed.
In the definition of the tobago sheet, the var definition: It's
arbitrary, I'm assuming and doesn't map to any real variables in any
beans.
Ok. So assuming a var definition of: QuarantineRec Then in the t:outs
if I'm using: quarantineRec.SENDER where SENDER is a database column
in the returned ResultSet.........
Does Tobago automatically know that SENDER is a db column?
No data showing in the Tobago sheet.
John
-----Original Message-----
From: Bernd Bohmann [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 1:28 AM
To: MyFaces Discussion
Subject: Re: Tobago sheet using jdbc ResultSet example request
John schrieb:
Thank you very much for the example.
The trick seems to be having a function called 'select' within the
backing bean, which tobago's sheet looks for to return data into the
resultSet which has been provided within the sheet's value.
Yes?
No, the select method is for the detail page.
The getSolarObjects() method is for the sheet.
The other get methods are for the detail page.
Bernd
--
Dipl.-Ing. Bernd Bohmann - Atanion GmbH - Software Development
Bismarckstr. 13, 26122 Oldenburg, http://www.atanion.com
phone: +49 441 4082312, mobile: +49 173 8839471, fax: +49 441 4082333
--
Dipl.-Ing. Bernd Bohmann - Atanion GmbH - Software Development
Bismarckstr. 13, 26122 Oldenburg, http://www.atanion.com
phone: +49 441 4082312, mobile: +49 173 8839471, fax: +49 441 4082333
