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
| if Request.QueryString ("Nom") <> "" then
sqlNom = "AND UCASE(a.X5NOMPRF) LIKE '" & ucase(Request.QueryString ("Nom")) & "%'"
else
sqlNom = ""
end if
if Request.QueryString ("Tel") <> "" then
sqlTel = "AND a.X5NUMTL1 LIKE '" & ucase(Request.QueryString ("Tel")) & "%'"
else
sqlTel = ""
end if
if Request.QueryString ("Iso") <> "" then
sqlIso = "AND a.X5USRPRF LIKE '" & ucase(Request.QueryString ("Iso")) & "%'"
else
sqlIso = ""
end if
if Request.QueryString ("Reso") <> "" then
sqlReso = "AND a.X5PRFRES LIKE '" & ucase(Request.QueryString ("Reso")) & "%'"
else
sqlReso = ""
end if
if Request.QueryString ("Entite") <> "" then
sqlAG = " AND a.X5CODAGC = '" & Request.QueryString ("Entite") &"'"
else
sqlAG = ""
end if
if Request.QueryString ("Lieu") <> "" then
'sqlAGABV = " AND LEFT(d.X0PHYOFF, 3) LIKE '" & Request.QueryString ("Lieu") & "%'"
sqlAGABV = " AND LEFT(d.X0PHYOFF, 3) = '" & Request.QueryString ("Lieu") & "' "
else
sqlAGABV = ""
end if
objCmd.CommandText = "SELECT a.X5USRPRF, a.X5NOMPRF, a.X5PNMPRF, a.X5NUMTL1, a.X5NUMTL2, a.X5EMAI, a.X5NOMAGC, a.X5NAGABV, a.X5PRFRES, a.X5TYPAGC, a.X5CODAGC, b.XTCODAGC, d.X0FAX FROM " & application("sBiblio") & ".XX0110F a, " & application("sBiblio") & ".XX0170F b, " & application("sBiblio") & ".XX0171F c, " & application("sBiblio") & ".XX0111F d WHERE LENGTH(TRIM(a.X5USRPRF))=3 "& sqlNom & sqlAg & sqlTel & sqlIso & sqlReso & sqlAGABV & " AND a.X5BOL002='0' AND b.XTNUMENT=a.X5CODAGC AND c.XACLE2=a.X5CODAGC AND b.XTDTDVAL<=" & session("nDateJour") & " AND b.XTDTFVAL>=" & session("nDateJour") & " AND c.XADTDVAL<=" & session("nDateJour") & " AND c.XADTFVAL>=" & session("nDateJour") & " AND d.X0NAME=a.X5USRPRF ORDER BY a.X5NOMPRF ASC"
set objRs = objCmd.Execute |
Partager