è possibile fare in modo con un ciclo while per prendere tutti i punti del db,cosi si vede solo il primo
<script src="http://maps.google.com/maps?file=api&v=2&key=miakey&sensor=true"
type="text/javascript"></script>
<%
Dim Conns
Set Conns = Server.CreateObject("ADODB.Connection")
Conns.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("db_punti.mdb")
sql = "SELECT * FROM tb_punti "
Set Rec = Server.CreateObject("ADODB.Recordset")
Rec.Open sql, Conns, 3, 3
coorx=Rec( "coorxgeo" )
coory=Rec( "coorygeo" )
varieta=Rec( "varieta" )
registro=Rec( "registro" )
foto=Rec("foto")
%>
<script type="text/javascript">
function initialize() {
if (GBrowserIsCompatible()) {
lat=('<%=Rec( "coorxgeo" )%>');
lon=('<%=Rec( "coorygeo" )%>')
registro=('<%=Rec( "registro" )%>')
varieta=('<%=Rec( "varieta" )%>')
foto=('<%=Rec( "foto" )%>')
var map = new GMap2(document.getElementById("map_canvas"));
var pianta = new GLatLng(lat,lon);
map.setMapType(G_SATELLITE_MAP);
map.setCenter(new GLatLng(lat,lon), 18);
map.setUIToDefault();
var icons = [];
icons["topix"] = new GIcon(G_DEFAULT_ICON, "/template/iconagoogle.png");
// var marker = new GMarker(point,icons["topix"]);
var marker = new GMarker(pianta,icons["topix"], {title: "('<%=azienda%>')"});
map.addOverlay(marker);
marker.openInfoWindowHtml("N°Registro:<%=registro%>
Varietà:<%=varieta%>
<a target=_blank href=public/<%=foto%>><img border=0 src=/public/<%=foto%> width=60 >");
}
}
</script>
<body onload="initialize()" onunload="GUnload()">
<div align="center">
<table border="0" width="500" cellspacing="0" cellpadding="0">
<tr>
<td><div id="map_canvas" style="width: 500px; height: 500px">
</td>
</tr>
</table>
</div>
</div>
</body>
Rispondi quotando
