Autodesk 15606-011408-9300 Developer Guide - Page 117

the Parcel Data ASP report, Autodesk MapGuide constructs a URL that, OBJ_KEYS, SQLQuery

Page 117 highlights

When a user selects one or more features from the Assessment layer and runs the Parcel Data (ASP) report, Autodesk MapGuide constructs a URL that invokes parcel_report.asp and tells it to generate a report on the selected features, which are identified by their OBJ_KEY values. If the user selected a single feature whose key was 941-0176-003-00, the URL would look like this: http://www.yourserver.com/asp/parcel_report.asp?OBJ_KEYS='9410176-003-00' If the user selected multiple features, the URL might look like this: http://www.yourserver.com/asp parcel_report.asp?OBJ_KEYS='941-0176-003-00','941-0176-006-00','941-0176-004-00' Note that OBJ_KEYS is represented as a standard URL parameter. To ASP, this parameter is no different from one submitted by an HTML form element. As we'll see in the next section, ASP processes it accordingly. Creating the Report Script Now let's create the ASP file that will process the Autodesk MapGuide report. The following code listing is for the parcel_report.asp file: ASP Report Data ASP Report Data Parcel Number: Owner: Year Built: Note that the VBScript code is almost identical to that in the first example ("Listing File Contents with ASP" on page 111). The only change is to the value we assign the SQLQuery variable. Creating Report Scripts with ASP | 117

  • 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

Creating Report Scripts with ASP
|
117
When a user selects one or more features from the Assessment layer and runs
the Parcel Data (ASP) report, Autodesk MapGuide constructs a URL that
invokes
parcel_report.asp
and tells it to generate a report on the selected
features, which are identified by their OBJ_KEY
values. If the user selected a
single feature whose key was 941-0176-003-00, the URL would look like this:
0176-003-00'
If the user selected multiple features, the URL might look like this:
parcel_report.asp?OBJ_KEYS='941-0176-003-00','941-0176-006-00','941-0176-004-00'
Note that
OBJ_KEYS
is represented as a standard URL parameter. To ASP, this
parameter is no different from one submitted by an HTML form element. As
we
ll see in the next section, ASP processes it accordingly.
Creating the Report Script
Now let
s create the ASP file that will process the Autodesk MapGuide report.
The following code listing is for the
parcel_report.asp
file:
<HTML>
<HEAD>
<TITLE>ASP Report Data</TITLE>
</HEAD>
<BODY>
<!-- code to create recordset -->
<%
Set dbConnection = Server.CreateObject("ADODB.Connection")
dbConnection.Open ("assessor")
SQLQuery = "SELECT * FROM Parcel_Data Where APN IN (" & Request.Form ("OBJ_KEYS") & ")"
Set RS = dbConnection.Execute(SQLQuery)
%>
<H1>ASP Report Data</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>
Note that the VBScript code is almost identical to that in the first example
(
Listing File Contents with ASP
on page 111). The only change is to the
value we assign the
SQLQuery
variable.