Try <dtml-if "_.len(genericSQL(SQLStatement='Select count(*) from my_table where my_field = \'0\''))>0"> YES! There's some data! <dtml-else> no records found! </dtml-if> or <dtml-in "genericSQL(SQLStatement='Select count(*) from my_table where my_field = \'0\'')"> <dtml-if sequence-start>YES! There's some data!</dtml-if> <dtml-else> no records found! </dtml-in> hth ----- Original Message ----- From: "zope" <zope@isp.lu> To: <zope@zope.org> Sent: Wednesday, November 15, 2000 4:22 PM Subject: [Zope] DTML and SQL question... | 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 - Zope@zope.org | 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 )