Autodesk 15606-011408-9300 Developer Guide - Page 118

Creating an HTML to Display the Map, Parcel_Data, Request.Form, Request, OBJ_KEYS

Page 118 highlights

As with the previous example, the statement is selecting records from the Parcel_Data DSN. The difference is that the SQL statement now points to Request.Form, the ASP Request object's Form collection. The Request object is used by ASP to parse submitted data received from a client as part of a URL. Form is a collection representing the URL parameters, which can be accessed from the collection by name. In this case, the collection has only one member, the OBJ_KEYS parameter we specified in Autodesk MapGuide Author. The SQL statement is basically saying to select in Parcel_Data all records whose APN field matches OBJ_KEYS. In other words, select the records that correspond to the selected features on the map. If OBJ_KEYS contains multiple keys, ASP outputs the feature data associated with each key. Creating an HTML Page to Display the Map The last step is to create an HTML page to display our map. The following listing is for the parcel_map.htm file: ASP Example Querying and Displaying Data via the Map This example uses ASP to access an Autodesk MapGuide Report 118 | 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

118
|
Chapter 6
Using Reports to Query and Update Data Sources
As with the previous example, the statement is selecting records from the
Parcel_Data
DSN. The difference is that the SQL statement now points to
Request.Form
, the ASP
Request
object
s
Form
collection. The
Request
object is used by ASP to parse submitted data received from a client as part of
a URL.
Form
is a collection representing the URL parameters, which can be
accessed from the collection by name. In this case, the collection has only
one member, the
OBJ_KEYS
parameter we specified in Autodesk MapGuide
Author.
The SQL statement is basically saying to select in
Parcel_Data
all records
whose APN field matches
OBJ_KEYS
. In other words, select the records that
correspond to the selected features on the map. If
OBJ_KEYS
contains
multiple keys, ASP outputs the feature data associated with each key.
Creating an HTML Page to Display the Map
The last step is to create an HTML page to display our map. The following
listing is for the
parcel_map.htm
file:
<HTML>
<HEAD>
<TITLE>ASP Example</TITLE>
</HEAD>
<BODY>
<H1>Querying and Displaying Data via the Map</H1>
<P>This example uses <b>ASP</b> to access an Autodesk MapGuide
Report</P>
<!-- embedded map -->
<OBJECT ID="map" WIDTH=600 HEIGHT=250
CLASSID="CLSID:62789780-B744-11D0-986B-00609731A21D">
<PARAM NAME="URL"
NAME="map"
WIDTH=600 HEIGHT=250>
</OBJECT>
</BODY>
</HTML>