%@ language = VBScript%> <% dim rs, strSql, nb_seminaires, tbl_seminaires, nb_formations, tbl_formations, iCpt set rs = server.CreateObject("ADODB.Recordset") rs.cursorLocation = 3 strSql = "SELECT * FROM SEMINAIRE WHERE bActif = 'o' ORDER BY pos" rs.open strSql, cn nb_seminaires = rs.recordCount if nb_seminaires > 0 then reDim tbl_seminaires(nb_seminaires) for iCpt = 1 to nb_seminaires rs.absolutePosition = iCpt tbl_seminaires(iCpt) = " " & rs("titre") & " - " & rs("dates") & " " & rs("lieu") next end if rs.close strSql = "SELECT * FROM FORMATION WHERE bActif = 'o' ORDER BY pos" rs.open strSql, cn nb_formations = rs.recordCount if nb_formations > 0 then reDim tbl_formations(nb_formations) for iCpt = 1 to nb_formations rs.absolutePosition = iCpt tbl_formations(iCpt) = " " & rs("titre") & " - " & rs("dates") & " " & rs("lieu") next end if rs.close function rep(txt) if not isNull(txt) and txt <> "" then rep = replace(txt, """", """) rep = replace(rep, "", "") rep = replace(rep, "", "") else rep = "" end if end function %>