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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 - [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 )
_______________________________________________
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 )