SQLQueue_reserveMessageList.zsql 452 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11
<dtml-comment>
title:
connection_id:cmf_activity_sql_connection
max_rows:0
max_cache:0
cache_time:0
class_name:
class_file:
</dtml-comment>
<params>processing_node
to_date
12
count
13 14 15 16 17 18 19 20 21 22
</params>
UPDATE
  message_queue
SET
  processing_node=<dtml-sqlvar processing_node type="int">
WHERE
  processing_node=0
  AND date <= <dtml-sqlvar to_date type="datetime">
ORDER BY
  priority, date, uid
23
LIMIT <dtml-sqlvar count type="int">
24 25
<dtml-var sql_delimiter>
COMMIT