Sub Initialize Dim s As New NotesSession Dim db As NotesDatabase Dim dc As NotesDocument Dim doc As NotesDocument Dim col As NotesDocumentCollection Dim rc As String Dim query As String Dim ajax As String Dim markup As String Dim status As String Dim option1 As String Dim option2 As String Dim option3 As String Set db = s.CurrentDatabase Set dc = s.DocumentContext rc = Join(dc.GetItemValue("request_content"), "") If(Len(rc) = 0) Then rc = Join(dc.GetItemValue("query_string"), "") Set col = db.AllDocuments Set doc = col.GetFirstDocument Do Until(doc Is Nothing) status = Join(doc.GetItemValue("status"), "") If(status = "") Then option1 = |<option selected value=""></option>| Else option1 = |<option value=""></option>| If(status = "Approved") Then option2 = |<option selected value="Approved">Approved</option>| Else option2 = |<option value="Approved">Approved</option>| If(status = "Rejected") Then option3 = |<option selected value="Rejected">Rejected</option>| Else option3 = |<option value="Rejected">Rejected</option>| markup = markup + |<tr>| +_ |<td class="col0">| + Join(doc.GetItemValue("title"), "") + |</td>| +_ |<td class="col1"><select name="status" id="status" onchange="moddoc(this.value, '| + Cstr(doc.UniversalID) + |');">| +_ option1+ option2 + option3 +_ |</td>| +_ |<td class="col2">| + Join(doc.GetItemValue("body"), "") + |</td>| +_ |</tr>| Set doc = col.GetNextDocument(doc) Loop Print |Content-type: text/plain| Print |<table><thead><tr>|+_ |<td class="col0">Title</td>|+_ |<td class="col1">Status</td>|+_ |<td class="col2">Body</td>|+_ |</tr></thead><tbody>| + markup + |</tbody></table>| End Sub
This LotusScript was converted to HTML using the ls2html routine,
provided by Julian Robichaux at nsftools.com.