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

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

Initial value:

RoutableSqlMethod(
        'posting_keyword_insert_sql',
        '',
        '''
POSTING_ID="" KEYWORD_LIST=""

KEYWORD_IN_SUBJECT=""
''',
        '''
<dtml-in KEYWORD_LIST>

  insert into POSTING_KEYWORD (
    POSTING_ID,
    KEYWORD,
    KEYWORD_IN_SUBJECT
  )
    values (
    <dtml-var "_.int(POSTING_ID)">,
    '<dtml-var "_.str(_['sequence-item'])" sql_quote>',
    <dtml-if KEYWORD_IN_SUBJECT>'t' <dtml-else>'f' </dtml-if>
  )

  <dtml-var sql_delimiter>

</dtml-in KEYWORD_LIST>

COMMIT

''')

Definition at line 188 of file sql.py.


Generated by  Doxygen 1.6.0   Back to index