La recherche sur les mots-clefs : search_mots_cles.asp et search_keyw_results.asp

version n°1 PB le 09/07/2001

search_mots_cles.asp
(Mettre ici une copie de l'écran - Commenter les différentes options)

search_keyw_result.asp

var keyword = "" + Request.Form ('keyw'); 
var sql_keyword = "" + Request.Form ('keyw'); 
var tables = "" + Request.Form ('tables'); 
var portee = "" + Request.Form ('portee'); 

//on remplace les éventuelles "*" dans le mot_clé par des "%" 
sql_keyword = replace(sql_keyword, "*", "%")

//traitement des apostrophes 
sql_keyword = replace(sql_keyword, "\'", "\'\'")

sqlquery = "select distinct ";

sqlquery += "documents.doc_titre, ";
sqlquery += "documents_versions.ver_no_valide, ";
sqlquery += "documents_versions.ver_no_projet, ";
sqlquery += "documents_pages.pag_titre, ";
sqlquery += "documents_pages.pag_type, ";
sqlquery += "documents_pages.pag_ref_info, "; 
sqlquery += "documents.doc_ref_orig, ";
sqlquery += "documents_mots_cles.key1, ";
sqlquery += "documents_mots_cles.key2, ";
sqlquery += "documents.doc_type_doc, "
sqlquery += "param_doc.par_txt_bouton "

sqlquery += "from documents, documents_versions, documents_pages, documents_mots_cles, param_doc ";
sqlquery += "where ";

sqlquery += "documents.doc_id = documents_versions.doc_id and ";
sqlquery += "documents_versions.doc_id = documents_pages.doc_id and "
sqlquery += "documents_pages.doc_id = documents_mots_cles.doc_id and "
sqlquery += "documents_versions.ver_id = documents_pages.ver_id and ";
sqlquery += "documents_pages.ver_id = documents_mots_cles.ver_id and "
sqlquery += "documents_pages.pag_id = documents_mots_cles.pag_id and "
sqlquery += "param_doc.dept_code = documents.doc_dept_code and ";
sqlquery += "param_doc.type_code = documents.doc_type_doc and ";

sqlquery += "(documents_mots_cles.key1 like '" + sql_keyword + "' or documents_mots_cles.key2 like '" + sql_keyword + "') "; 
sqlquery += "and ('" + portee + "' = 'all' or (";
sqlquery += "documents_versions.ver_no_projet = 0 and ";
sqlquery += "documents_versions.ver_application_date <= '" + Session ("date_visu") + "' and ";
sqlquery += "documents_versions.ver_peremption_date > '" + Session ("date_visu") + "'";
sqlquery += ")) and '" + tables + "' like 'proc%' ";
sqlquery += " and documents.doc_dept_code = '" + Session ("dept_code") + "'";

sqlquery += " UNION ";

sqlquery += "select distinct ";

sqlquery += "annexes.ann_titre, ";
sqlquery += "annexes_versions.van_no_valide, ";
sqlquery += "annexes_versions.van_no_projet, ";
sqlquery += "annexes_versions.van_titre, ";
sqlquery += "'Ann', "
sqlquery += "annexes_versions.van_ref_info, "; 
sqlquery += "annexes.ann_ref_orig, ";
sqlquery += "annexes_mots_cles.key1, ";
sqlquery += "annexes_mots_cles.key2, ";
sqlquery += "documents.doc_type_doc, ";
sqlquery += "param_doc.par_txt_bouton "

sqlquery += "from annexes, annexes_versions, annexes_mots_cles, documents, param_doc ";
sqlquery += "where ";

sqlquery += "documents.doc_id = annexes.doc_id and ";
sqlquery += "annexes.doc_id = annexes_versions.doc_id and ";
sqlquery += "annexes_versions.doc_id = annexes_mots_cles.doc_id and ";
sqlquery += "annexes_versions.ann_id = annexes_mots_cles.ann_id and "
sqlquery += "annexes.ann_id = annexes_versions.ann_id and ";
sqlquery += "annexes_versions.van_id = annexes_mots_cles.van_id and ";
sqlquery += "param_doc.dept_code = annexes.ann_dept_code and ";
sqlquery += "param_doc.type_code = (select documents.doc_type_doc from documents where documents.doc_id = annexes.doc_id) and ";

sqlquery += "(annexes_mots_cles.key1 like '" + sql_keyword + "' or annexes_mots_cles.key2 like '" + sql_keyword + "') "; 
sqlquery += "and ('" + portee + "' = 'all' or (";
sqlquery += "annexes_versions.van_no_projet = 0 and ";
sqlquery += "annexes_versions.van_application_date < '" + Session ("date_visu") + "' and ";
sqlquery += "annexes_versions.van_peremption_date > '" + Session ("date_visu") + "'";
sqlquery += ")) and '" + tables + "' like '%annx'";
sqlquery += " and annexes.ann_dept_code = '" + Session ("dept_code") + "'";

sqlquery += " order by doc_type_doc,key1,key2";

Colonnes affichées :

    CLE 1 : Première clé 
    CLE 2 : Seconde clé 
    DOC_TITRE : titre du document 
    'VERSION' : ver_no_valide ou van_no_valide + "." + ver_no_projet ou van_no_projet 
    PAG_TITRE : titre de la page avec lien vers cette page (van_ref_info). 
    PAG_TYPE : documents_pages.pag_type ou 'ann' 
    DOC_REF_ORIG : doc_ref_orig ou ann_ref_orig