Okay, I know nothing and I admit it. I have a simple form with a set
of buttons at the top and depending on the button you push, displays
some data at the button of the form. This is probably to much info,
but the sub actually gets the data from a SQL server and then
dynamically builds the table to display at the bottom of the page.
I would like to divide this single page into two pages so that I can
have all the buttons in one frame and the results in another
frame...how do I do this? Heres an example of my html (just one button
shown here):
<html>
<head>
<body>
<Script Language="VBScript">
Sub btnListBackups_OnClick()
Set oConnection = CreateObject("ADODB.Connection")
oConnection.Open "Provider=SQLOLEDB" & _
";Data Source=" & "DBDELTA1" & _
";Integrated Security=SSPI"
Set recordSet = oConnection.Execute("EXEC tempdb..sp_lastback")
myResultTable = "<table border=""1"">"
myResultTable = myResultTable & "<tr>"
For i = 0 To recordSet.Fields.Count - 1
myResultTable = myResultTable & _
"<th>" & _
recordSet.Fields(i).Name & _
"</th>"
Next
myResultTable = myResultTable & "</tr>"
Do While Not recordSet.EOF
myResultTable = myResultTable & "<tr>"
For i = 0 To recordSet.Fields.Count - 1
myResultTable = myResultTable & _
"<td>" & _
recordSet.Fields(i).Value & _
"</td>"
Next
myResultTable = myResultTable & "</tr>"
recordSet.MoveNext
Loop
myResultTable = myResultTable & "</table>"
recordSet.Close
oConnection.Close
Results.innerHTML = myResultTable
End Sub
</script>
<input type="button" id="btnListBackups" value="List Backups">
<hr>
<nobr Id=Results></nobr>
</body>
</html>
