Fra recordset til javascript
Måske har jeg gjort tingene lidt svære for mig selv, men jeg har brug for en metode til at fylde data i en iframe fra top-framen baseret på en værdi fra et recordset.Noget i retning af:
frames.ReserverForm.document.MinForm.Titel.value = rs(\"Titel\")
Den nuværende kode:
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">
<html>
<head>
<title>Booking Manager</title>
</head>
<script language=\"JavaScript\" src=\"/Booking/Menu/navcond.js\"></script>
<script language=\"JavaScript\" src=\"/Booking/Menu/Menu.js\"></script>
<script language=\"JavaScript\">
function registrer(){
document.reservation.Titel.value = frames.ReserverForm.document.MinForm.Titel.value;
document.reservation.Start.value = frames.ReserverForm.document.MinForm.Start.value;
document.reservation.Slut.value = frames.ReserverForm.document.MinForm.Slut.value;
document.reservation.Personer.value = frames.ReserverForm.document.MinForm.Personer.value;
document.reservation.RekID.value = frames.ReserverForm.document.MinForm.RekID.value;
document.reservation.AntalFrokost.value = frames.ReserverForm.document.MinForm.AntalFrokost.value;
document.reservation.Formiddag.value = frames.ReserverForm.document.MinForm.Formiddag.value;
document.reservation.Frokost.value = frames.ReserverForm.document.MinForm.Frokost.value;
document.reservation.Eftermiddag.value = frames.ReserverForm.document.MinForm.Eftermiddag.value;
document.reservation.Aften.value = frames.ReserverForm.document.MinForm.Aften.value;
document.reservation.Diverse.value = frames.ReserverForm.document.MinForm.Diverse.value;
document.reservation.VaegKombi.value = frames.ReserverForm.document.MinForm.VaegKombi.value;
document.reservation.Dato.value = frames.Datovalg.document.Wiz.Dato.value;
document.reservation.TavleVisning.value = frames.ReserverForm.document.MinForm.TavleVisning.value;
validerForm();
}
function validerForm(){
check=0;
if(document.reservation.Start.value >= document.reservation.Slut.value){
alert(\'Starttiden skal være mindre end Sluttiden\');
check++;
}
if(document.reservation.Personer.value == \'\'){
alert(\'Du har ikke angivet antallet af personer\');
check++;
}
if(document.reservation.AntalFrokost.value == \'\'){
alert(\'Du har ikke angivet antallet af frokostdeltagere\');
check++;
}
if(check==0)
document.reservation.submit();
//alert(check);
else
alert(\'Reservationen kunne ikke gemmes: \' + check);
}
</script>
<body onload=\"init()\">
<br>
<br><br>
<%
ResID = Request.QueryString(\"ResID\")
response.write \"ResID: \" & ResID & \"<br>\"
\'Connection til Personaleaendringernes database paa Sql-Serveren
Set conn = Server.CreateObject(\"ADODB.Connection\")
conn.open \"DSN=BookingData;uid=sa;pwd=;APP=BookingDB;Database=BookingDB\"
sql=\"SELECT * FROM Reservation WHERE ResID=\" & ResID
set rs= conn.execute(sql)
%>
<h1>Reserver lokaler</h1>
<iframe name=\"ReserverForm\" src=\"Form.asp\" height=260 width=700 marginwidth=0 hspace=0 vspace=0 frameborder=1 scrolling=no bordercolor=black></iframe>
<iframe name=\"Datovalg\" src=\"../DatePicker/Default.asp\" height=260 width=245 marginwidth=0 hspace=0 vspace=0 frameborder=1 scrolling=no bordercolor=black></iframe>
<br>
<form name=\"reservation\" action=\"gem.asp\">
<input type=\"Hidden\" name=\"Dato\">
<input type=\"Hidden\" name=\"Titel\">
<input type=\"Hidden\" name=\"Start\">
<input type=\"Hidden\" name=\"Slut\">
<input type=\"Hidden\" name=\"Personer\">
<input type=\"Hidden\" name=\"RekID\">
<input type=\"Hidden\" name=\"AntalFrokost\">
<input type=\"Hidden\" name=\"Formiddag\">
<input type=\"Hidden\" name=\"Frokost\">
<input type=\"Hidden\" name=\"Eftermiddag\">
<input type=\"Hidden\" name=\"Aften\">
<input type=\"Hidden\" name=\"Diverse\">
<input type=\"Hidden\" name=\"VaegKombi\">
<input type=\"Hidden\" name=\"TavleVisning\">
<input type=\"Button\" width=\"200\" onclick=\"JavaScrpit:registrer()\" value=\"Gem Reservation\" align=\"left\">
</form>
</body>
</html>
<%
rs.close
conn.close
%>
