Autodesk 15606-011408-9300 Developer Guide - Page 106
<CFQUERY>, <SCRIPT>, InsertQuery, Assessor, Data entered in
UPC - 606121429548
View all Autodesk 15606-011408-9300 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 106 highlights
The following illustration shows the showform.cfm form, as displayed in the window created by getpoint.cfm. Data entered in the showform.cfm form 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.cfm file: insert.cfm?rpt_lat=37.721&rpt_lon=121.943&rpt_info=A+hat+was+stolen&rpt_by=J+Bigby Now, let's see how the insert.cfm file handles the URL: INSERT into Incidents (lat, lon, description, reported_by) values('#FORM.rpt_lat#','#FORM.rpt_lon#','#FORM.rpt_info#','#FORM. rpt_by#') alert("Point added successfully! Reload the map to see your changes."); window.close(); The file consists of and tags. Like getpoint.cfm, the file contains no displayable text. The tag defines a query named InsertQuery using the Assessor DSN from the previous examples. Note that the query name is defined, but not used again in the file. 106 | Chapter 6 Using Reports to Query and Update Data Sources