Autodesk 15606-011408-9300 Developer Guide - Page 114

Seeing the Results, do the following until you reach the end

Page 114 highlights

This is a good start, but not quite what we want. To cycle through the records, we'll need to add some sort of looping code. That's what the two scripts are for. The beginning script contains a single line, which operates on the RS object. RS.EOF represents RS object's end-of-file property. In effect, the line is saying do the following until you reach the end: Do While Not RS.EOF The ending block contains two lines, one that advances to the next record in the recordset and another that finishes up the loop structure: RS.MoveNext Loop Now we're ready to load the page in our browser. Seeing the Results Here's a listing of the complete ASP file parcel_report.asp: ASP Test #1 ASP Test #1 Parcel Number: Owner: Year Built: 114 | Chapter 6 Using Reports to Query and Update Data Sources

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208

114
|
Chapter 6
Using Reports to Query and Update Data Sources
This is a good start, but not quite what we want. To cycle through the
records, we
ll need to add some sort of looping code. That
s what the two
scripts are for.
The beginning script contains a single line, which operates on the
RS
object.
RS.EOF
represents
RS
object
s end-of-file property. In effect, the line is saying
do the following until you reach the end:
Do While Not RS.EOF
The ending block contains two lines, one that advances to the next record in
the recordset and another that finishes up the loop structure:
RS.MoveNext
Loop
Now we
re ready to load the page in our browser.
Seeing the Results
Here
s a listing of the complete ASP file
parcel_report.asp
:
<HTML>
<HEAD>
<!-- code to create recordset -->
<%
Set dbConnection = Server.CreateObject("ADODB.Connection")
dbConnection.Open ("Assessor")
SQLQuery = "SELECT * FROM Parcel_Data Where YearBlt = '1963'"
Set RS = dbConnection.Execute(SQLQuery)
%>
<TITLE>ASP Test #1</TITLE>
</HEAD>
<BODY>
<H1>ASP Test #1</H1>
<!-- output code -->
<%
Do While Not RS.EOF
%>
<P>Parcel Number: <%=RS("APN")%><BR>
Owner: <%=RS("Owner")%><BR>
Year Built: <%=RS("yearblt")%></P>
<%
RS.MoveNext
Loop
%>
</BODY>
</HTML>