1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
sub querylevel(parentobject,BG,BD,niveau, user_id)
dim rsHits, queryString, gFldStr
queryString = "SELECT NMC_ID, NMC_LIBELLE, NMC_NIVEAU, NMC_BG, NMC_BD, (NMC_BD-NMC_BG) as descendant, date_created FROM FOLDER_NOMENCLATURE_NMC t1, FOLDER_NOMENCLATURE_user t2 " &_
"WHERE t2.id_user = " & user_id &" and t2.id_folder = t1.NMC_ID" &_
" and NMC_BG>"&BG &" and NMC_BD<"& BD &"and NMC_NIVEAU = "& niveau+1 &"ORDER by NMC_LIBELLE asc"
Set rsHits = Conn.Execute(queryString)
do while not rsHits.EOF
[...]
if rsHits("descendant") >1 then
querylevel parentObject & "Sub", rsHits("NMC_BG") , rsHits("NMC_BD") ,rsHits("NMC_NIVEAU"), user_id
end if
rsHits.MoveNext
loop
rsHits.close
end sub
sub outputJavascript(user_id)
dim rsHits, queryString, gFldStr
queryString = "SELECT NMC_ID, NMC_LIBELLE, NMC_NIVEAU, NMC_BG, NMC_BD FROM FOLDER_NOMENCLATURE_NMC WHERE NMC_NIVEAU = 0 and id_user = " & UserIDPere
Set rsHits = Conn.Execute(queryString)
[...]
querylevel "f", rsHits("NMC_BG") , rsHits("NMC_BD") ,rsHits("NMC_NIVEAU"), user_id
rsHits.close
end sub |
Partager