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

Author:

davis@xarg.net

Created:

2004-04-01

Partial Call Graph (max 5 caller/called nodes):

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