Brad Moulton writes:
 > I would like to build a table depending on some tests peformed on stuff
 > returned form a Z SQL method
 > 1. I have a form with a name="spam" value="egs"
 > this value is passed onto next dtml document
 > ---------------------------------
 > table
 > <tr>
 > <td><dtml-var spam> <td>             // displays 'eggs'  to test spam is OK
 > </tr>
 > <dtml-var sqlstuff>                  // this does a join of two tables 
 > <dtml-in sqlstuff>
 > <dtml-if {CAN'T WORK OUT SYNTAX TO ACCESS  spam to compare with lets say
 > sqlstuff.spam}
 > <tr><td><dtml-var sqlstuff.column></td>....etc
 > </dtml-if>
 > </dtml-in>  
 > ----------------------------------------------
Your problem is solved by renaming.

You can either rename your DTML var or your SQL column result name:

DTML var:

  <dtml-let myspam=spam> <!-- you can now access "spam" as "myspam"-->
    <dtml-in sqlstuff>
       <dtml-if "myspam == spam">....</dtml-if>

SQL column result name:

  select spam as sqlspam ...

You now access the "spam" column under the name "sqlspam".

I, regularly, use SQL column renaming.


Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to