Hi.

I want to test if there is some data in a table.
If so, I want to perform some action, otherwise I wan't to print out a message.
(<dtml-if>..<dtml-else>..</dtml-if>)

My SQL statement is something like:

Select count(*) from my_table where my_field = something

What DTML code do I need to perform that if-statement?

Something like the following does not work :-(

<dtml-if "genericSQL(SQLStatement='Select count(*) from my_table where 
my_field = \'0\'') == 0">
   YES! There's some data!
<dtml-else>
   no records found!
</dtml-in>

Thanks for any help.

Greetings, Marc Ludwig
Luxembourg


_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to