<% Response.Expires = 60 Response.Expiresabsolute = Now() - 1 Response.AddHeader "pragma","no-cache" Response.AddHeader "cache-control","private" Response.CacheControl = "no-cache" %> La Vitrine virtuelle de l'ERE <%'-------dÈclaration de la base------------------------------ DSN_BASE = "DBQ=" & Server.Mappath("vitrine.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};Driverld=25"%>
 


<%'----------------OBJECTIF : LISTER LES organismes corespondants-------------------%> <%'-------crÈation de la connection et du recordset-------------------------- Set ConnSponsor = Server.CreateObject("ADODB.Connection") ConnSponsor.Open DSN_BASE Set RsSponsor = Server.CreateObject("ADODB.Recordset") Set RsProduit = Server.CreateObject("ADODB.Recordset") Dim contienlettre(33) For i = 1 to 33 contienlettre(i) = false next Dim lstalpha(33) lstalpha(1)="A" lstalpha(2)="Ë" lstalpha(3)="å" lstalpha(4)="B" lstalpha(5)="C" lstalpha(6)="D" lstalpha(7)="E" lstalpha(8)="ƒ" lstalpha(9)="é" lstalpha(10)="æ" lstalpha(11)="F" lstalpha(12)="G" lstalpha(13)="H" lstalpha(14)="I" lstalpha(15)="ë" lstalpha(16)="J" lstalpha(17)="K" lstalpha(18)="L" lstalpha(19)="M" lstalpha(20)="N" lstalpha(21)="O" lstalpha(22)="ï" lstalpha(23)="P" lstalpha(24)="Q" lstalpha(25)="R" lstalpha(26)="S" lstalpha(27)="T" lstalpha(28)="U" lstalpha(29)="V" lstalpha(30)="W" lstalpha(31)="X" lstalpha(32)="Y" lstalpha(33)="Z"%>

 

 

Organismes

 

La Vitrine virtuelle de l’ERE est maintenant en opération. Veuillez toutefois noter que certains organismes nouvellement inscrits compléteront leur fiche descriptive dans les prochains jours. Pour plus d’information sur l’inscription, consultez la rubrique Membres.

 

 

 

Québec'ERE

 

<%For i = 1 to 33%> <%'-------dÈfinition des la requÍte des produit de l'organisme RsSponsor.Open "SELECT * FROM organisme where nom like'"&lstalpha(i)&"%' order by nom", ConnSponsor%> <%if not RsSponsor.eof then%> <%if lstalpha(i) = "Ë" or lstalpha(i) = "å" or lstalpha(i) = "ƒ" or lstalpha(i) = "é" or lstalpha(i) = "æ" or lstalpha(i) = "ï" or lstalpha(i) = "ë"then%> <%contienlettre(i) = true %> <%end if%> <%end if RsSponsor.close next %> <%For i = 1 to 33%> <%'-------dÈfinition des la requÍte des produit de l'organisme RsSponsor.Open "SELECT * FROM organisme where nom like'"&lstalpha(i)&"%' order by nom", ConnSponsor%> <%if not RsSponsor.eof then%> <%if lstalpha(i) <> "Ë" and lstalpha(i) <> "å" and lstalpha(i) <> "ƒ" and lstalpha(i) <> "é" and lstalpha(i) <> "æ" and lstalpha(i) <> "ï" and lstalpha(i) <> "ë"then%> <%response.write(lstalpha(i))%> <% contienlettre(i) = true %> <%else if lstalpha(i) = "Ë" and contienlettre(1) = false then %> <%response.write(lstalpha(1))%> <%end if%> <%if lstalpha(i) = "å" and contienlettre(1) = false then %> <%response.write(lstalpha(1))%> <%end if%> <%if lstalpha(i) = "ƒ" and contienlettre(7) = false then %> <%response.write(lstalpha(7))%> <%end if%> <%if lstalpha(i) = "é" and contienlettre(7) = false then %> <%response.write(lstalpha(7))%> <%end if%> <%if lstalpha(i) = "æ" and contienlettre(7) = false then %> <%response.write(lstalpha(7))%> <%end if%> <%if lstalpha(i) = "ë" and contienlettre(14) = false then %> <%response.write(lstalpha(14))%> <%end if%> <%if lstalpha(i) = "ï" and contienlettre(21) = false then %> <%response.write(lstalpha(21))%> <%end if%> <%end if %> <% else%> <%if lstalpha(i) <> "Ë" and lstalpha(i) <> "å" and lstalpha(i) <> "ƒ" and lstalpha(i) <> "é" and lstalpha(i) <> "æ" and lstalpha(i) <> "ï" and lstalpha(i) <> "ë"then%> <%if lstalpha(i) <> "A" and lstalpha(i) <> "E" and lstalpha(i) <> "I" and lstalpha(i) <> "O"then%> <%response.write(lstalpha(i))%> <%else%> <%if lstalpha(i) = "A" and contienlettre(2) = false and contienlettre(3) = false then %> <%response.write(lstalpha(i))%> <%end if%> <%if lstalpha(i) = "E" and contienlettre(8) = false and contienlettre(9) = false and contienlettre(10) = false then %> <%response.write(lstalpha(i))%> <%end if%> <%if lstalpha(i) = "I" and contienlettre(15) = false then %> <%response.write(lstalpha(i))%> <%end if%> <%if lstalpha(i) = "O" and contienlettre(22) = false then %> <%response.write(lstalpha(i))%> <%end if%> <%end if%> <%end if %> <%end if RsSponsor.close next %>

 


<%For i = 1 to 33%> <%'-------dÈfinition des la requÍte des produit de l'organisme RsSponsor.Open "SELECT * FROM organisme where nom like'"&lstalpha(i)&"%' order by nom", ConnSponsor%> <%if not RsSponsor.eof then%> <%if lstalpha(i) <> "Ë" and lstalpha(i) <> "å" and lstalpha(i) <> "ƒ" and lstalpha(i) <> "é" and lstalpha(i) <> "æ" and lstalpha(i) <> "ï" and lstalpha(i) <> "ë"then%>
<%response.write(lstalpha(i))%>
<%else if lstalpha(i) = "Ë" and contienlettre(1) = false then %> <%response.write(lstalpha(1))%>
<%end if%> <%if lstalpha(i) = "å" and contienlettre(1) = false then %> <%response.write(lstalpha(1))%>
<%end if%> <%if lstalpha(i) = "ƒ" and contienlettre(7) = false then %> <%response.write(lstalpha(7))%>
<%end if%> <%if lstalpha(i) = "é" and contienlettre(7) = false then %> <%response.write(lstalpha(7))%>
<%end if%> <%if lstalpha(i) = "æ" and contienlettre(7) = false then %> <%response.write(lstalpha(7))%>
<%end if%> <%if lstalpha(i) = "ë" and contienlettre(14) = false then %> <%response.write(lstalpha(14))%>
<%end if%> <%if lstalpha(i) = "ï" and contienlettre(21) = false then %> <%response.write(lstalpha(21))%>
<%end if%> <%end if %> <%do while not RsSponsor.eof%> "><%=RsSponsor("nom")%>
<%RsSponsor.MoveNext loop end if RsSponsor.close next %>