Autodesk 15606-011408-9300 Developer Guide - Page 107

The element contains a single SQL Insert statement, which is used to add the form data to the map resource database. The SQL Insert statement adds data to a database resource, in this case the Incidents table in the assessor DSN. The parenthetical values lat, lon, description, and reported_by are the names of the database fields we want to supply values for. The parenthetical values #FORM.rpt_lat#, #FORM.rpt_lon#, #FORM.rpt_info#, and #FORM.rpt_by# represent the information we want to place into the URL parameters passed by showform.cfm. The first line of the element 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 To create an HTML page to display our map, we'll use parcel_map.htm, modifying only the and the short paragraph of descriptive text: ColdFusion Example Modifying a Database via the Map This example uses ColdFusion to update a database map resource Creating a Custom Menu Item There a few problems with this design. One is that it requires users to select View ➤ Reports from the popup menu, then select Incidents (CF) from the list, then clear the JavaScript alert box that tells them to select a point, and then digitize the point. Another problem is that because our report isn't associated with a layer, users can add items to the Incidents map layer even when that layer isn't visible. Creating Report Scripts with ColdFusion | 107