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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
| <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html>
<head>
<title>Test photos</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%
' Objet de connexion ADO
Set conn = Server.CreateObject ("ADODB.Connection")
' Ouvrir la base avec DSN
conn.open "b"
Set rs = Server.CreateObject("ADODB.RecordSet")
sql = "Select * from Vente where Vente.Dom='ch' and Vente.Numero = " & 44888
rs.Open sql, CONN,3,2,1
%>
<script language="JavaScript">
var ph1=new Image();
ph1.src="/Photos/" + <%=rs("Photo1")%>;
var ph2=new Image();
ph2.src="/Photos/" + <%=rs("Photo2")%>;
var ph3=new Image();
ph3.src="/Photos/" + <%=rs("Photo3")%>;
var ph4=new Image();
ph4.src="/Photos/" + <%=rs("Photo4")%>;
var ph5=new Image();
ph5.src="/Photos/" + <%=rs("Photo5")%>;
function montre2(){
document.images.ph1.src=ph2.src;
}
function montre3(){
document.images.ph1.src=ph3.src;
}
function montre4(){
document.images.ph1.src=ph4.src;
}
function montre5(){
document.images.ph1.src=ph5.src;
}
</script>
</head>
<body>
<table width="40%" border="1">
<tr>
<td><div align="center"><img src="/Photos/<%=rs("Photo1")%>" width="240" name="ph1"></div></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><div align="center"><a href="#" onMouseOver="montre2()"><img src="/Photos/<%=rs("Photo2")%>" width="60" name="photo2"></a> <img src="/Photos/<%=rs("Photo3")%>" width="60" name="photo3"> <img src="/Photos/<%=rs("Photo4")%>" width="60" name="photo4"> <img src="/Photos/<%=rs("Photo5")%>" width="60" name="photo5"> </div></td>
</tr>
</table>
</body>
<%
rs.close
set rs = nothing
CONN.close
set CONN = nothing
%>
</html> |
