[Zope] DTML and SQL question...

[Phil Harris]

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 )