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

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

Initial value:

RoutableSqlMethod(
        'thread_get_all_messages_sql',
        '',
        '''
THREAD_ID=""
''',
        '''
select
  P.POSTING_ID,
  P.PARENT_ID,
  P.THREAD_ID,
  P.AUTHOR,
  P.POSTING_SUBJECT,
  P.POSTING_BODY,
  P.DATE_CREATED,
  P.DATE_LAST_REPLY,
  P.NUMBER_OF_REPLIES,
  P.POSTING_PRIORITY,
  P.THREAD_LOCKED
from
  POSTING P
where
  (P.POSTING_ID = <dtml-var "_.int(THREAD_ID)"> or P.THREAD_ID = <dtml-var "_.int(THREAD_ID)">)
  and P.SHOW_POSTING ='t'
order by
  P.DATE_CREATED


''')

Definition at line 219 of file sql.py.


Generated by  Doxygen 1.6.0   Back to index