[Zope-DB] ZSql and evaluating the results for a 0 or 1 - Newbie help

[Steven.Klass at smsc.com]

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.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20060721/3e72874a/attachment.htm