SQLQueue_hasMessage.zsql 431 Bytes
<dtml-comment>
title:
connection_id:cmf_activity_sql_connection
max_rows:1
max_cache:100
cache_time:1
class_name:
class_file:
</dtml-comment>
<params>path
method_id</params>
SELECT count(path) as message_count FROM
  message_queue
<dtml-if "path or method_id"> 
WHERE
<dtml-if path>  path = <dtml-sqlvar path type="string"></dtml-if>
<dtml-if method_id>AND method_id = <dtml-sqlvar method_id type="string"></dtml-if>
</dtml-if>