Steven.Klass at smsc
Jul 21, 2006, 2:27 PM
Post #1 of 3
(1247 views)
Permalink
|
|
ZSql and evaluating the results for a 0 or 1 - Newbie help
|
|
Hi all,
I have a very simple thing I want to do... (yeah I know famous last
words). I am querying a mysql database and displaying the results.. Then
I decided that I want to get a bit fancier.. tal:content item/results
value is either a 1 or a 0.
If item/results is == 0 I want to display "Pass" in green.
If item/results is == 1 I want to display "Fail" in red.
Can someone please help the newbie out?
My document as it stands today..
====================================================
<h4 tal:define="global item python:container.metriX.RemotePush()"
tal:condition="not:item">There Are No Items meeting the query</h4>
<table class="sortable" id="rpush" summary="Remote Push"
tal:condition="item">
<tr>
<td width="20%">Update Time</td>
<td width="15%">Host</td>
<td width="15%">Update</td>
<td width="50%">Files</td>
<td width="2%">Attempts</td>
</tr>
<tbody tal:repeat="item python:container.metriX.RemotePush()">
<tr class="even" tal:condition="repeat/item/even">
<td tal:content="item/last_update">update</td>
<td tal:content="item/host">host</td>
<td tal:content="item/return_val">ret</td>
<td tal:content="item/results">pass</td>
<td tal:content="item/num_attempts">attempts</td>
</tr>
<tr class="odd" tal:condition="repeat/item/even">
<td tal:content="item/last_update">update</td>
<td tal:content="item/host">host</td>
<td tal:content="item/return_val">ret</td>
<td tal:content="item/results">results</td>
<td tal:content="item/num_attempts">attempts</td>
</tr>
</tbody>
</table>
comp.web.zope.database/
---
Steven M. Klass
Design Automation Manager
SMSC
3930 East Ray Road, Suite 200
Phoenix, Arizona 85044
(480) 704-7046 (Desk)
(480) 225-1112 (Mobile)
steven.klass [at] smsc
|
