Logo Search packages:      
Sourcecode: zope-cmfpgforum version File versions

tuple CMFpgForum::sql::SQLMethods::reply_verify_parent_and_thread [static, inherited]

Initial value:

RoutableSqlMethod(
        'reply_verify_parent_and_thread',
        '',
        '''
PARENT_POSTING_ID="" THREAD_ID=""

MESSAGE_BOARD_ID=""
''',
        '''
select
  P.POSTING_ID
from
  POSTING P
where
  P.POSTING_ID = <dtml-var "_.int(THREAD_ID)">
  <dtml-unless "_.int(PARENT_POSTING_ID) == _.int(THREAD_ID)">
    and P.POSTING_ID in (select P2.THREAD_ID from POSTING P2
                 where P2.POSTING_ID = <dtml-var "_.int(PARENT_POSTING_ID)">)
  </dtml-unless>
  and P.MESSAGE_BOARD_ID = <dtml-var "_.int(MESSAGE_BOARD_ID)">

''')

Definition at line 363 of file sql.py.


Generated by  Doxygen 1.6.0   Back to index