faq_qanda::fts::datasource (private)

 faq_qanda::fts::datasource entry_id

Defined in packages/faq/tcl/faq-sc-procs.tcl

returns a datasource for a faq q/a to be indexed by the full text search engine.

Parameters:
entry_id (required)
Author:
davis@xarg.net
Created:
2004-04-01

Partial Call Graph (max 5 caller/called nodes):
%3 AcsSc.ftscontentprovider.datasource.faq_q_and_a AcsSc.ftscontentprovider.datasource.faq_q_and_a (private) faq_qanda::fts::datasource faq_qanda::fts::datasource AcsSc.ftscontentprovider.datasource.faq_q_and_a->faq_qanda::fts::datasource db_0or1row db_0or1row (public) faq_qanda::fts::datasource->db_0or1row db_string db_string (public) faq_qanda::fts::datasource->db_string

Testcases:
No testcase defined.
Source code:
    set title [db_string name {
        select f.faq_name from faqs f
        where faq_id = (select faq_id from faq_q_and_as where entry_id = :entry_id)
    } -default "FAQ $entry_id"]

    if {[db_0or1row get {select question, answer from faq_q_and_as where entry_id = :entry_id}]} {
        append title ": $question"
        set content "Q: $question\n\nA: $answer\n\n"
    } else {
        set content {}
    }

    return [list object_id $entry_id  title $title  content $content  keywords {}  storage_type text  mime text/plain ]
XQL Not present:
Generic, PostgreSQL, Oracle
[ hide source ] | [ make this the default ]
Show another procedure: