15 Nov
2000
15 Nov
'00
4:22 p.m.
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