Autodesk 15606-011408-9300 Developer Guide - Page 131

Creating an HTML to Display the Map, See your ASP docu

Page 131 highlights

Note If a user enters an apostrophe (like the one found in can't, won't, and doesn't) into the showform.asp form, it will cause a syntax error when ASP tries to execute the SQL statement. To avoid this, add code to replace a single apostrophe with two apostrophes as follows: Change Request.Form("rpt_info") to Replace(Request.Form("rpt_info See your ASP documentation for more information. In the element, the first line displays an alert telling users to reload the map to see their changes. The second line closes the form window, leaving only the original map window. Creating an HTML Page to Display the Map The last step is to create an HTML page to display our map. We'll use the parcel_map.htm file from the previous example, modifying the and the short paragraph of descriptive text, but leaving the rest of the file unchanged: ASP Example Modifying a Database via the Map This example uses ASP to update a database map resource Creating Report Scripts with ASP | 131

  • 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
|
131
Note
If a user enters an apostrophe (like the one found in can
t, won
t, and
doesn
t) into the
showform.asp
form, it will cause a syntax error when ASP tries to
execute the SQL statement. To avoid this, add code to replace a single apostro-
phe with two apostrophes as follows: Change
Request.Form("rpt_info")
to
Replace(Request.Form("rpt_info"),"'","''")
. See your ASP docu-
mentation for more information.
In the
<SCRIPT>
element, the first line displays an alert telling users to
reload the map to see their changes. The second line closes the form window,
leaving only the original map window.
Creating an HTML Page to Display the Map
The last step is to create an HTML page to display our map. We
ll use the
parcel_map.htm
file from the previous example, modifying the
<H1>
and the
short paragraph of descriptive text, but leaving the rest of the file unchanged:
<HTML>
<HEAD>
<TITLE>ASP Example</TITLE>
</HEAD>
<BODY>
<!-- Only the next two lines are different -->
<H1>Modifying a Database via the Map</H1>
<P>This example uses <b>ASP</b> to update a database map
resource</P>
<!-- embedded map -->
<OBJECT ID="map" WIDTH=600 HEIGHT=250
CLASSID="CLSID:62789780-B744-11D0-986B-00609731A21D">
<PARAM NAME="URL"
Right>
<EMBED
ghtNAME="map" WIDTH=600 HEIGHT=250>
</OBJECT>
</BODY>
</HTML>