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>
Rispondi quotando
