Home » Autodesk Manuals » Computer Software » Autodesk 15606-011408-9300 » Manual Viewer

Autodesk 15606-011408-9300 Developer Guide - Page 130

<SCRIPT&gt, CreateObject, Server, Connection, Assessor, Request.Form, Request.QueryString, SQLQuery

Get Autodesk 15606-011408-9300 - MAPGUIDE R6.3 UPG PDF manuals and user guides

UPC - 606121429548

View all Autodesk 15606-011408-9300 manuals

Add to My Manuals
Save this manual to your list of manuals

Page 130 highlights

Specifying the lat/lon point 37.721,-121.943 by clicking the map and filling out the form as shown in the illustration will result in the following URL being constructed and passed to the insert.asp file: insert.asp?rpt_lat=37.721&rpt_lon=121.943&rpt_info=A+cat+was+stolen&rpt_by=J+Appell Now we'll see how insert.asp handles the URL:

Section	Page
Developer’s Guide	1
Contents	3
Introduction	7
What’s New in Release 6	8
Autodesk DWG Data Source Support	8
Enhanced Support for Map Redraw Operations	8
Symbol Bitmap Support	8
Map Mode Retrieval Support	9
Java Edition Platform Support Changes	9
Before You Begin	9
Familiarity with Autodesk MapGuide	9
Programming and Scripting Languages	10
Your Audience	10
User Help	11
About the Autodesk MapGuide Viewer API	11
Autodesk MapGuide Viewer API Help	13
Autodesk MapGuide Web Site	13
What Is an Autodesk MapGuide Viewer API Application	13
Viewing Maps	14
Querying and Updating Data	14
Creating an Autodesk MapGuide Viewer API Application	15
Displaying Maps	17
Overview	18
Map Display for ActiveX Control and Plug-In	20
Linking to a Map	20
Displaying a Linked Map in a Different Window or Frame	21
Displaying a Specific Area of the Map	21
Embedding a Map	22
Embedding a Map in a Frame-Based Page	23
Map Display for the Java Edition	24
Map Display for Autodesk MapGuide LiteView	26
Installing Viewers on Client Machines	27
Accessing Maps	31
Overview	32
Map Access for ActiveX Control and Plug-In	32
Required Software for Autodesk MapGuide Viewer Plug-In	34
Map Access for the Java Edition	35
Map Access from HTML	35
Using JavaScript or JScript	35
Map Access Using Java	38
Wrapper Java Applet	38
Peer Java Applet	38
Wrapper Java Application	38
Required Software for the Java Edition	39
Java Edition Differences	39
Functional Differences with Java Edition	39
Browser Differences with Java Edition	40
Communicating with the Plug-In from a Java Applet	40
Accessing the Plug-In from a Java Applet	41
Calling JavaScript Functions from a Java Applet	42
Accessing Secure Data	43
Handling Busy State and Map Refresh	43
About the Busy State	43
Controlling Map Refresh Operations	45
Using the autoRefresh Flag	45
AutoRefresh Flag Caveats	46
Detecting Map Refreshes	46
Detecting a Change in the Busy State	46
Controlling Intermediate Update Map Redraw Operations	47
Handling Errors	47
Getting Error Codes	47
Checking for Incorrect Argument Types	48
Debugging an Application	48
Working with Map Layers, Map Features, and Printing	49
Overview	50
Working with Map Layers	50
Counting Map Layers	50
Listing Map Layers	51
Adding a Map Layer	53
Linking Map Layers	53
Toggling Map Layer Visibility On and Off	55
Working with Map Features	56
Getting Keys of Selected Map Features	56
Getting Coordinates of a Selected Map Feature	58
Invoking Select Radius Mode	61
Zooming In on Selected Features	61
Counting Map Features	62
Working with Printing	64
Setting the Print Priority	65
Enabling the Print Events	66
Positioning Page Elements with Page Coordinate System Units	67
Adding Custom Page Elements	68
Handling Events	69
Overview	70
Working with Event Handlers	70
Browser Differences	71
Event Observer Set Methods	71
Setting Up Event Handlers	72
Plug-In and Java Edition Event Handlers	72
ActiveX Control Event Handlers	75
Plug-In and ActiveX Control Event Handlers	75
VBScript Example	75
JavaScript Example	77
VBScript and JavaScript Example	78
Writing Event Handlers	78
Page Setup Event Handler Example	79
Print Event Handler Example	81
Plug-In Event Handler Example	83
Using Reports to Query and Update Data Sources	85
Overview	86
How Reports Are Generated	86
Specifying the Report Script	86
The Request	87
Launching the Report	87
Introducing ColdFusion and ASP	88
Creating Report Scripts with ColdFusion	89
Listing File Contents with ColdFusion	89
Setting Up the Query	90
Controlling the Output	90
Seeing the Results	90
Querying and Displaying Data via the Map with ColdFusion	92
Setting Up the Report in Autodesk MapGuide Author	92
Creating the Report Script	94
Creating an HTML Page to Display the Map	95
Seeing the Results	95
Redirecting Report Output	96
Adding a Button with the Viewer API	100
Modifying a Database via the Map with ColdFusion	102
Setting Up the Report in Autodesk MapGuide Author	103
Creating the Report Scripts	104
Creating an HTML Page to Display the Map	107
Creating a Custom Menu Item	107
Accessing Your Application with the Viewer API	108
Creating Report Scripts with ASP	109
Summary of ASP Objects, Components, and Events	110
Listing File Contents with ASP	111
Specifying a Scripting Language	112
Selecting Database Records	112
Controlling the Output	113
Seeing the Results	114
Querying and Displaying Data via the Map with ASP	115
Setting Up the Report in Autodesk MapGuide Author	116
Creating the Report Script	117
Creating an HTML Page to Display the Map	118
Seeing the Results	119
Redirecting Report Output	120
Adding a Button with the Viewer API	122
Modifying a Database via the Map with ASP	125
Setting Up the Report in Autodesk MapGuide Author	126
Creating the Report Scripts	127
Creating an HTML Page to Display the Map	131
Creating a Custom Menu Item	132
Accessing Your Application with the Viewer API	133
Applications	135
Overview	136
Custom Redlining Application	136
Redlining Example Code	137
Municipal Application	140
Municipal Application Example Code	141
Facility Management Application	156
Facilities Management Application Example Code	157
DWG Filtering Application	164
Understanding Layers in Autodesk MapGuide	165
Changing Map Layer Data Source Properties	165
DWG Filtering Application Example Code	166
Selection Changed Function (selChanged)	166
Show Properties Function (showProperties)	168
SDF Component Toolkit Applications	171
Updating SDF Files—an ASP Example	171
Converting to an SDF File—a Visual Basic Example	181
Getting SDF File Information—a Visual Basic Example	188
Copying an SDF File—a Visual Basic Example	196
Index	203
A	203
B	203
C	203
D	204
E	204
F	205
G	205
H	205
I	205
J	205
K	205
L	205
M	206
N	206
O	206
P	206
Q	207
R	207
S	207
U	207
V	207
W	208
X	208

Match case Limit results 1 per page

130

Chapter 6

Using Reports to Query and Update Data Sources

Specifying the lat/lon point 37.721,-121.943 by clicking the map and filling

out the form as shown in the illustration will result in the following URL

being constructed and passed to the

insert.asp

file:

insert.asp?rpt_lat=37.721&rpt_lon=-

121.943&rpt_info=A+cat+was+stolen&rpt_by=J+Appell

Now we

’

ll see how

insert.asp

handles the URL:

Set dbConnection = Server.CreateObject("ADODB.Connection")

dbConnection.Open("assessor")

SQLQuery =

"INSERT into Incidents (lat, lon, description, reported_by)" & _

"values('" & Request.Form("rpt_lat") & "','" & _

Request.Form("rpt_lon") & "','" & Request.Form("rpt_info") & _

"','" & Request.Form("rpt_by") & "')"

dbConnection.Execute(SQLQuery)

alert("Point added successfully! Reload the map to see your

changes.");

window.close();

</SCRIPT>

getpoint.asp

, the file contains no displayable text. Instead, it contains

two blocks of code. One is an ASP script, written in VBScript. The other is an

HTML

element containing JavaScript code.

The first line of code uses the

CreateObject

method of the

Server

object

to create a new

Connection

object, which is assigned to a variable called

dbConnection

The next line opens a connection to the data source name (DSN), in this case

Assessor

, and assigns that connection to the

dbConnection

variable. Note

that

Open

is a method of the

Connection

object, in this case

dbConnection

The third line creates a variable that holds an SQL statement specifying the

data we want to add to the Incidents table.

Because

insert.asp

is receiving its information directly from a form (instead of

from a URL we constructed programmatically), we call

Request.Form

instead of

Request.QueryString

. After

Request.Form

supplies the values

from

showform.asp

, the line looks like this:

SQLQuery =

"INSERT into Incidents (lat, lon, description, reported_by)" & _

"values('37.721','-121.943','A cat was stolen','J Appell')"

The last line runs the SQL statement we assigned to

SQLQuery

, adding the

new record to the database.