% Maire=request.form("C1") Coll=request.form("C2") If Maire = "Nom des Maires" then If Coll = "Nom des Collectivités" then Response.Redirect "elus.asp" else Sqlq="select * from COLLECTIVITES where NomCollect='"&Coll&"'" end if else Sqlq="select * from COLLECTIVITES where NomResp='"&Maire&"' " end if set fp_rs = Server.CreateObject("ADODB.Recordset") fp_rs.Open Sqlq, "DSN=amf82" if fp_rs.EOF then Response.Write(Cstr(Coll)) if fp_rs.EOF then Response.Redirect "elus.asp" %>
|
|
.
<%if NOT IsNull(fp_rs("NOMRESP")) AND (fp_rs("QUALRESP")="1") then %> |
<% if NOT IsNull(fp_rs("NOMCOLLECT")) then %>
<%=CStr(fp_rs("NomCollect"))%><% if NOT IsNull(fp_rs("Telephone")) then %> Téléphone: <% end if if NOT IsNull(fp_rs("Telephone")) then%> <%=CStr(fp_rs("Telephone"))%> <% end if if NOT IsNull(fp_rs("Fax")) then %>Télécopie: <% end if if NOT IsNull(fp_rs("Fax")) then%> <%=CStr(fp_rs("Fax"))%> <% end if htm=fp_rs("LienHt1") file=Replace(CStr(htm)," ","_") Set FileObject = Server.CreateObject("Scripting.FileSystemObject") PathFichhtm = Server.MapPath(file) if FileObject.FileExists(PathFichhtm) then%> <% end if if NOT IsNull(fp_rs("MAIL")) then%>"><%=CStr(fp_rs("MAIL"))%> <%end if%> |
|
|
||