good day,

create a ZSQLMethod ... let`s call it genericSQL
having your sql query in it, then do a

<dtml-if "genericSQL(_.None,_)">
   YES! There's some data!
<dtml-else>
   no records found!
</dtml-if>

in your DTML Method

not tested.
but should work.

regards.
--
pashah

-----Original Message-----
From: zope <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 15 ноября 2000 г. 19:38
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>



_______________________________________________
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