% varsql1 = "Select * from record WHERE rc_attivo='S' " rs.open varsql1, con ,3,3 fotobase="http://www.interholidays.it/eguest/ftp-guest" IF rs.eof THEN response.redirect("http://www.interholidays.it") END IF rs.Movelast foto_1 =fotobase&rs("rc_foto") data_1 = rs("rc_data") comm_1 = rs("rc_commento") sql1 = "Select * from strutture WHERE ht_nome='"&rs("rc_struttura")&"'" rs1.open sql1, con ,3,3 hote_1 = rs1("ht_desc1")& " - "& rs1("ht_desc3") rs1.close rs.moveprevious foto_2 =fotobase&rs("rc_foto") data_2 = rs("rc_data") comm_2 = rs("rc_commento") sql1 = "Select * from strutture WHERE ht_nome='"&rs("rc_struttura")&"'" rs1.open sql1, con ,3,3 hote_2 = rs1("ht_desc1")& " - "& rs1("ht_desc3") rs1.close rs.moveprevious foto_3 =fotobase&rs("rc_foto") data_3 = rs("rc_data") comm_3 = rs("rc_commento") sql1 = "Select * from strutture WHERE ht_nome='"&rs("rc_struttura")&"'" rs1.open sql1, con ,3,3 hote_3 = rs1("ht_desc1")& " - "& rs1("ht_desc3") rs1.close rs.moveprevious foto_4 =fotobase&rs("rc_foto") data_4 = rs("rc_data") comm_4 = rs("rc_commento") sql1 = "Select * from strutture WHERE ht_nome='"&rs("rc_struttura")&"'" rs1.open sql1, con ,3,3 hote_4 = rs1("ht_desc1")& " - "& rs1("ht_desc3") rs1.close rs.moveprevious foto_5 =fotobase&rs("rc_foto") data_5 = rs("rc_data") comm_5 = rs("rc_commento") sql1 = "Select * from strutture WHERE ht_nome='"&rs("rc_struttura")&"'" rs1.open sql1, con ,3,3 hote_5 = rs1("ht_desc1")& " - "& rs1("ht_desc3") rs1.close %>