ciao Ragazzi
mi potete dare una mano per questa cavolata, che purtroppo la mia ignorante testolina non riesce a fare?

dovrei tirare fuori la % tra impression e click ho provato a scrivere la stringa
ma l'errore è questo
Microsoft VBScript runtime error '800a000d'

Type mismatch: 'rs'

/testBanner/banner/banner_update_ute.asp, line 96

grazie







codice:



	
codice:

	
<%
bannerid = request.querystring("bannerid")

sql = "select * from rb_banner where bannerid="&bannerid
set rs = Server.CreateObject("ADODB.Recordset")

rs.open sql, objConn
 
do until rs.eof

 
	nome = rs("nome")
	redirecturl = rs("redirecturl")
	url_banner = rs("url_banner")
	peso = rs("peso")
	alttext = rs("alttext")
	showcount = rs("showcount")
	clickcount = rs("clickcount")
	id_set = rs("id_set")
	maxclicks = rs("maxclicks")
	maximpression = rs("maximpression")
	validofinoa = rs("validofinoa")
	validodal = rs("validodal")
	id_adv = rs("id_adv")
 
	if maxclicks = 2147483647 then
		maxclicks = ""
	end if
	 
	if maximpression = 2147483647 then
		maximpression = ""
	end if
	 
	if validofinoa = "31/12/20" then
		validofinoa = ""
	end if
	 
	if validodal = "01/01/99" then
		validodal = ""
	end if
 
rs.movenext
loop

rs.close
set rs=nothing
%>
<html>
<head>
	<title><%=pagetitle%></title>
	<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body bgcolor="#ffffff" text="#000000">
<p align="center">[img]../images/Intest_Banner.gif[/img]</p>



<center>
<table cellpadding="0" cellspacing="0" border="0" width="80%">
	<tr>
		<td class="tab1">
			<table cellpadding="2" cellspacing="1" border="0" width="100%">
			<form action="banner_action_banner.asp" method="post" id=form1 name=form1>
						<input type="hidden" name="id_set" value="<%=request.querystring("id_Set")%>">
						<input type="hidden" name="bannerid" value="<%=request.querystring("bannerid")%>">
						<input type="hidden" name="action" value="update">
						<tr>
					<td class="tab2">Nome banner:</td>
					<td class="tab3"><%=nome%>
</td>
				</tr>
				<tr>
					<td class="tab2">Url destinazione:</td>
					<td class="tab3"><%=redirecturl%>
</td>
				</tr>
				<tr>
					<td class="tab2">Url banner:</td>
					<td class="tab3"><%=url_banner%>
</td>
				</tr>
				<tr>
					<td class="tab2">Clic stop:</td>
					<td class="tab3"><%=maxclicks%></td>
				</tr>

				<tr>
					<td class="tab2">Clic ricevuti:</td>
					<td class="tab3"><%=rs("clickcount")%></td>
				</tr>
				<tr>
					<td class="tab2">Impression stop:</td>
					<td class="tab3"><%=maximpression%></td>
				</tr>
				<tr>
					<td class="tab2">Impression:</td>
					<td class="tab3"><%=rs("showcount")%>
</td>
				</tr>
				        <tr>

					<td class="tab2">Percentuale %</td>
					<%if rs("showcount")>0 then perc=round(rs("clickcount")/rs("showcount")*100,2) else perc=0 end if%> 
					<td class="tab3"><%=perc%>%</td>
				        </tr>
				<tr>
					<td class="tab2">Data inizio:</td>
					<td class="tab3"><%=validodal%></td>
				</tr>
				</form>
			</table>
		</td>
	</tr>
</table>
</center>
</body>
</html>