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
