asked on

Updating record in a asp page

I am trying to update a record from an asp page using a couple of values from my form. However, I am getting an error. Any idea why this might not be working?

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.
/CE/CE_Post2LDB_3.asp, line 1079

This works:
strsql = "UPDATE Events SET Events.MallID = 125 WHERE (((Events.EventID)=39));"
This does not.
strsql = "UPDATE Events SET Events.MallID = " & varMall_ID & " WHERE (((Events.EventID)=" & varEvent_ID & "));"

<% 
            dim strDataPath, strConnectString, objConnection,  objRS, strSelected, strFDSID, strLat, strLon
            dim varMall_ID, varEvent_ID, strsql
            varMall_ID = Request.Form("txtMallID")
            varEvent_ID = Request.Form("txtEventID")
 
            strDataPath = server.MapPath("\Databases\CompEvents.mdb")   
            strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;"_
			            + " Data Source= " & strDataPath & ";"_
			            + " Mode=Share Deny None;User Id=admin;PASSWORD=;"
            			
            			
            if not IsObject("ojbConnection") then
	            set objConnection=Server.CreateObject("ADODB.Connection")
	            objConnection.ConnectionTimeout = 15
	            objConnection.CommandTimeout =  10
	            objConnection.Mode = 3 'adModeReadWrite 
	            if objConnection.State = 0 then
		            objConnection.Open strConnectString
	            end if
            end if
 
            if not isObject("objRS") then
                set objRS=Server.CreateObject("ADODB.RecordSet")
            end if
            strsql = "UPDATE Events SET Events.MallID = " &  varMall_ID & " WHERE (((Events.EventID)=" & varEvent_ID & "));"
            //strsql = "UPDATE Events SET Events.MallID = 125 WHERE (((Events.EventID)=39));"
 
                   //'objRS.Open "SELECT MONTHLYOLD.[New Division] FROM MONTHLYOLD WHERE (((MONTHLYOLD.Latitude)<>0) AND ((MONTHLYOLD.Longitude)<>0)) GROUP BY MONTHLYOLD.[New Division] HAVING (((MONTHLYOLD.[New Division])<>''));",objConnection,3,3
                    objRS.Open strsql, objConnection,3,3
 		 	        //objRS.Close
			        set objRS=Nothing
            %>

Open in new window

ChetOS82

do a Response.Write(strsql) : Response.End() after line 27 and tell me what is displayed.

ASKER CERTIFIED SOLUTION

Member_2_3718378

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Member_2_3718378

Or rather, an extra unpaired parenthesis.

flfmmqp

ASKER

If I hard code the values it also does not work.
varMall_ID = "39"
varEvent_ID = "7777"

I tried the response.write but the page does not like it. I also changed the strsql as suggested but it did not work either.

It is an asp page and below is all of the code. The javascript that I am working on is at the very bottom of the page.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
	<head>
		<title>Competitive Event Location Finder for LDB </title>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
		<!--    <link rel="stylesheet" type="text/css" href="http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dijit/themes/tundra/tundra.css">
-->
		<style type="text/css"> @import "http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dijit/themes/tundra/tundra.css"; @import "http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dojox/grid/_grid/tundraGrid.css"; 
	</style>
		<script type="text/javascript">djConfig = { parseOnLoad:true }</script>
		<script type="text/javascript" src="http://serverapi.arcgisonline.com/jsapi/arcgis/?v=1.1"></script>
		<script type="text/javascript" src="./querystring.js"></script>
		<!-- <script type="text/javascript">djConfig = {parseOnLoad:true, isDebug:true };</script>
<script type="text/javascript" src="http://serverapi.arcgisonline.com/jsapi/arcgis/?v=1.1"></script>-->
<!--Start Needed for floating Panel-->
 
 
<style type="text/css">
@import "http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dojo/resources/dojo.css";
@import "http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dijit/themes/dijit.css";
@import "http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dijit/themes/nihilo/nihilo.css";
@import "http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dijit/themes/nihilo/nihilo_rtl.css";
@import "http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dojox/layout/resources/FloatingPane.css";
@import "http://serverapi.arcgisonline.com/jsapi/arcgis/1.1/js/dojo/dojox/layout/resources/ResizeHandle.css";
/* body { background:url('gridUnderlay.png') top left; }  */
 
.alternateDock {
	position:absolute;
	background-color:#ededed;
	right:0px;
	top:0px;
	border-left:0px solid #ccc;
	height:100%;
}
#alternateDock ul.dojoxDockList {
	display:block;
}
body {
	padding:2em 2em 2em 2em;
}
</style>
<!--End Needed for floating Panel-->
<script type="text/javascript">
 
      dojo.require("esri.map");
      dojo.require("esri.tasks.locator");
 
 
      dojo.require("esri.toolbars.navigation");
      dojo.require("dijit.form.Button");
      dojo.require("dijit.Toolbar");
 
      dojo.require("esri.toolbars.draw");
      
    //Grid Control Stuff
      dojo.require("esri.tasks.query");
      dojo.require("dojox.grid.Grid");
      dojo.require("dojox.grid._data.model");
         
 
    //Title Pane
      dojo.require("dojo.parser");
      dojo.require("dijit.TitlePane");
 
 
    //Combobox
      dojo.require("esri.tasks.geometry");
      dojo.require("esri.tasks.gp");
 
       //Make references for dojo controls for the floating panels/title panes
      dojo.require("dijit.form.TextBox");
      dojo.require("dijit.Dialog");
      dojo.require("dojo.data.ItemFileWriteStore");  //Used for the Neighborhood dropdown list
      dojo.require("dijit.dijit"); // optimize: load dijit layer
      dojo.require("dijit.form.ComboBox");
 
      dojo.require("dijit.ProgressBar");
      dojo.require("dojox.layout.FloatingPane"); 
 
 
      var map, locator2, navToolbar, Imagery, Transportation, mapScales;
 
 
 
      var queryTask, query;
      var queryTaskCBSA, queryCBSA;
      //Variables for map services/lyaers
      var streetMap, imagery, portlandService, dynamicMapServiceLayer;
      //Varaibles for identify task, identify parameters
      var identify, identifyParams;
      var layerIdPrefix = "layerId";
      //varaibles for Query Task for querying a parcel
        
        //Variables for Macys Stores
        var defaultSymbol, highlightSymbol, resultTemplate;
 
 
		var qs = new Querystring();
		var id=qs.get('id','N/A');
		var DMA=qs.get('DMA','N/A');
		var Retailer=qs.get('Retailer',"N/A");
		var DMAID=qs.get('DMAID','N/A');
 
      var queryTaskSelectStores, querySelectStores, infoTemplateStores, symbolStores;
      var queryTaskSelectMalls, querySelectMalls, infoTemplateMalls, symbolMalls;   
      var queryDMAConnection, queryZipConnection, queryCountiesConnection, queryESRIConnection, QueryGetLocationInformation;
      var locator, infoTemplate, Address, State, Zip, City, symbol;
      var graphic, graphicAddress, graphicState, graphicZip, graphicCity, screenPnt;
      
      function init() {
	////----- Getting value from URL for ID, Retailer and DMA ----////
	////---- in order for this to work you need this line  type="text/javascript" src="./querystring.js"> ---///
	////----and you need the associated file querystring.js ----////
		// Parse the current page's querystring
		var tboxEventID = document.getElementById('txtEventID');
		var tboxDMA = document.getElementById('txtEventDMA');
		var tboxRetailer = document.getElementById('txtEventRetailer');
		var tboxDMAID = document.getElementById('txtDMAID');
 
		// ... repeat for each textbox
		tboxEventID.value = qs.get('id');
		tboxDMA.value = qs.get('DMA');
		tboxRetailer.value = qs.get('Retailer');
		tboxDMAID.value = qs.get('DMAID');
 
 
		
		
		//var divTitle = document.getElementById('titlepaneCE');
		//divTitle.setAttribute("title", "http://ho000xd3840571/CE/CE_GridViewDetails.aspx?id=" + id);	
			
		//div.setAttribute("href", "http://ho000xd3840571/CE/CE_GridViewDetails.aspx?id=" + id);		
		//dojo.byId("CE_Detail").setHref = ("http://ho000xd3840571/CE/CE_GridViewDetails_plain.aspx?id=68");
 
 
 
	////----- End Getting value from URL for ID, Retailer and DMA ----////
 
//        map = new esri.Map("map", { extent: new esri.geometry.Extent(-95.2991, 38.9379, -95.2476, 38.963, new esri.SpatialReference({wkid:4326})) });
//          extent: new esri.geometry.Extent(-125.9016637859635, 44.600742276385304, -114.6516637859635, 50.225742276385304, new esri.SpatialReference({wkid:4326})),
//        map = new esri.Map("map", {
//          extent: new esri.geometry.Extent(-119.1, 34.5, -117.1, 33.75, new esri.SpatialReference({wkid:4326})),
//          showInfoWindowOnClick:true
//        });
       map = new esri.Map("map", {
          extent: new esri.geometry.Extent(-125.9016637859635, 44.600742276385304, -114.6516637859635, 50.225742276385304, new esri.SpatialReference({wkid:4326})),
          showInfoWindowOnClick:true
        });        
        
//        //Working with a debugger.
//        dojo.connect(map, "onLoad", function() {
//          console.log("Map loaded");
          dojo.connect(map, "onExtentChange", function(extent) { console.log("Extent changed : " + dojo.toJson(extent.toJson())); });
 
//        dojo.connect(map, "onLayerAdd", function() { console.log("Layer added"); });
 
        //Imagery Layers from ArcGIS
            //Add the I-cubed imagery from ArcGIS Online as the primary basemap layer.
            Imagery = new esri.layers.ArcGISTiledMapServiceLayer("http://server.arcgisonline.com/ArcGIS/rest/services/ESRI_Imagery_World_2D/MapServer", {id:"Imagery", visible:true});
            map.addLayer(Imagery);
            dojo.byId("rdImg").checked=true;
  			 
  			//Add the ArcGIS Online Streetmap layer as a secondary basemap.
  			Transportation = new esri.layers.ArcGISTiledMapServiceLayer("http://server.arcgisonline.com/ArcGIS/rest/services/ESRI_StreetMap_World_2D/MapServer", {id:"Transportation", visible:false});
  			map.addLayer(Transportation);
  			dojo.byId("rdStreetLayer").checked=false;
 
 
            //Add Area Research CBSA Layer
  			CBSA = new esri.layers.ArcGISDynamicMapServiceLayer("http://ho000xd3840571/ArcGIS/rest/services/CBSA/MapServer", {id:"CBSA", opacity:"0.5", visible:false});
  			map.addLayer(CBSA);
   			dojo.byId("chkCBSA").checked=false; 
   			
//            //Add Area Research DMA Layer
  			var DMAS = new esri.layers.ArcGISDynamicMapServiceLayer("http://ho000xd3840571/ArcGIS/rest/services/DMAS_Only/MapServer", {id:"DMAS", opacity:"0.5", visible:false});
  			map.addLayer(DMAS);
   			dojo.byId("chkDMAS").checked=false;
   			
//            //Add Area Research Counties Layer
  			var Counties = new esri.layers.ArcGISDynamicMapServiceLayer("http://ho000xd3840571/ArcGIS/rest/services/Counties_Only/MapServer", {id:"Counties", opacity:"0.5", visible:false});
  			map.addLayer(Counties);
   			dojo.byId("chkCounties").checked=false;   			
   			
            //Add Area Research Zips Layer
  			var Zips = new esri.layers.ArcGISDynamicMapServiceLayer("http://ho000xd3840571/ArcGIS/rest/services/Zips_Only/MapServer", {id:"Zips", opacity:"0.5", visible:false});
  			map.addLayer(Zips);
   			dojo.byId("chkZips").checked=false;
 
            //This zooms us to the DMA of the event.
  			//build query tasks for DMA
  			queryDMATask = new esri.tasks.QueryTask("http://ho000xd3840571/ArcGIS/rest/services/DMAS_Only/MapServer/0");
  	 		queryDMA = new esri.tasks.Query();
  			queryDMA.returnGeometry = true;
  			queryDMA.outFields = ["DMANAME", "DMAID"];
            queryDMAConnection = dojo.connect(map, "onClick", executeQueryDMATask); 
 
            zoom_DMA()
			
        //Start of Add Stores
            queryTaskSelectStores = new esri.tasks.QueryTask("http://ho000xd3840571/ArcGIS/rest/services/MacysStoresOnly/MapServer/0");
            querySelectStores = new esri.tasks.Query();
            querySelectStores.where = "Division <> ''";
            querySelectStores.returnGeometry = true;
            querySelectStores.outFields = ["FDSID", "STORENAME", "DIVABBREVI", "FYSALES", "GROSS", "MALL_GRADE"];
            infoTemplateStores = new esri.InfoTemplate("${STORENAME}", "STORENAME : ${STORENAME}<br/> FDSID : ${FDSID}<br />DIVABBREVI : ${DIVABBREVI}");
		        //create symbol for selected features
		        symbolStores = new esri.symbol.SimpleMarkerSymbol();
		        symbolStores.setStyle(esri.symbol.SimpleMarkerSymbol.STYLE_CIRCLE);
		        symbolStores.setSize(10);
		        symbolStores.setColor(new dojo.Color([230,0,0,0.75]));            
        //End of Add Stores
 
 
        //Start of Add Malls
            queryTaskSelectMalls = new esri.tasks.QueryTask("http://ho000xd3840571/ArcGIS/rest/services/CE_Malls/MapServer/0");
            querySelectMalls = new esri.tasks.Query();
            //querySelectMalls.where = "DMA = '561'";
            querySelectMalls.where = "DMA = '" + DMAID + "'";
            querySelectMalls.returnGeometry = true;
            //querySelectMalls.outFields = ["MALL_ID", "MALL_NAME", "CITY", "DMA", "TYPE"];
            querySelectMalls.outFields = ["MALL_ID", "MALL_NAME", "CITY", "DMA", "ANCHORS"];
 
 
            infoTemplateMalls = new esri.InfoTemplate("${MALL_NAME}", "MALL_NAME : ${MALL_NAME}<br/> MALL_ID : ${MALL_ID}<br />CITY : ${CITY}<br />Anchors : ${ANCHORS}<br /><br /><input id='cmdSaveExistingRecord' type='button' value='Save Info' onclick='return SaveValue_onclick(${MALL_ID})'/>");
 
 
		        //create symbol for selected features
		        symbolMalls = new esri.symbol.SimpleMarkerSymbol();
		        symbolMalls.setStyle(esri.symbol.SimpleMarkerSymbol.STYLE_SQUARE);
		        symbolMalls.setSize(10);
		        symbolMalls.setColor(new dojo.Color([255,255,0,0.75]));            
    			dojo.byId("chkMalls").checked=true; 
  				queryTaskSelectMalls.execute(querySelectMalls, showResultsMalls);
 
        //End of Add Malls
 
 
 
 
        ////---- Start of filling in Zip, County and DMA Code----------////
  			//build query tasks for County
  			queryCountiesTask = new esri.tasks.QueryTask("http://ho000xd3840571/ArcGIS/rest/services/Counties_Only/MapServer/0");
  	 		queryCounties = new esri.tasks.Query();
  			queryCounties.returnGeometry = true;
  			queryCounties.outFields = ["COUNTY", "STCO", "YEAR"];
            queryCountiesConnection = dojo.connect(map, "onClick", executeQueryCountiesTask);
            
  			queryZipTask = new esri.tasks.QueryTask("http://ho000xd3840571/ArcGIS/rest/services/Zips_Only/MapServer/0");
  	 		queryZip = new esri.tasks.Query();
  			queryZip.returnGeometry = true;
  			queryZip.outFields = ["ZIPCODE"];
            queryZipConnection = dojo.connect(map, "onClick", executeQueryZipsTask);            
 
 
        
        ////---- End of filling in Zip, County and DMA Code----------////
 
        //Toolbar stuff
        esriConfig.defaults.map.sliderLabel = null;
        navToolbar = new esri.toolbars.Navigation(map);
        dojo.connect(navToolbar, "onExtentHistoryChange", extentHistoryChangeHandler);
 
 
        //Locate Map Click information
        //radAddressLocatorOn
            locator = new esri.tasks.Locator("http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Locators/ESRI_Geocode_USA/GeocodeServer");
            infoTemplate = new esri.InfoTemplate("Address1", "Street: ${Address}<br />City: ${City}<br />State: ${State}<br />Zip: ${Zip}");
            Address = new esri.InfoTemplate("Address", "${Address}");
            State = new esri.InfoTemplate("State", "${State}");
            Zip = new esri.InfoTemplate("Zip", "${Zip}");
            City = new esri.InfoTemplate("City", "${City}");
            symbol = new esri.symbol.SimpleMarkerSymbol(esri.symbol.SimpleMarkerSymbol.STYLE_CIRCLE, 15, new esri.symbol.SimpleLineSymbol(esri.symbol.SimpleLineSymbol.STYLE_SOLID, new dojo.Color([0,0,255]), 2), new dojo.Color([0,0,255]));
 
              dojo.connect(locator, "onLocationToAddressComplete", function(candidate) {
                  if (candidate.address) {
                   graphic = new esri.Graphic(candidate.location, symbol, candidate.address, infoTemplate);
                   graphicAddress = new esri.Graphic(candidate.location, symbol, candidate.address, Address);
                   graphicState = new esri.Graphic(candidate.location, symbol, candidate.address, State);
                   graphicZip = new esri.Graphic(candidate.location, symbol, candidate.address, Zip);
                   graphicCity = new esri.Graphic(candidate.location, symbol, candidate.address, City);
                    
                    map.infoWindow.setTitle(graphic.getTitle());
                    map.infoWindow.setContent(graphic.getContent());
                    screenPnt = map.toScreen(candidate.location);
                    document.getElementById("txtGNAddress").value = graphicAddress.getContent();
                    document.getElementById("txtGNState").value = graphicState.getContent();
                    document.getElementById("txtGNZip").value = graphicZip.getContent();
                    document.getElementById("txtGNCity").value = graphicCity.getContent();  
                  }
              });
              dojo.connect(map, "onExtentChange", onMapExtentChange);
              queryESRIConnection = dojo.connect(map, "onClick", executeQueryESRITask);            
 
//              queryESRIConnection = dojo.connect(map, "onClick", function(evt) {
//                  locator.locationToAddress(evt.mapPoint, 100);
//                  document.getElementById("txtMapLat").value = evt.mapPoint.y;
//                  document.getElementById("txtMapLon").value = evt.mapPoint.x;
//                  UpdateGraphics()
//                  //map.graphics.clear();
//                 addGraphic(evt.mapPoint.x, evt.mapPoint.y)
//              });
              ///------ Turn off clicking on map for now. -----////
                    dojo.disconnect(queryDMAConnection);
                    dojo.disconnect(queryZipConnection);
                    dojo.disconnect(queryCountiesConnection);
                    dojo.disconnect(queryESRIConnection);
 
      }
 
 
 
 
      function executeQueryESRITask(evt){
       alert("executeQueryESRITask")
       //function(evt) {
                  locator.locationToAddress(evt.mapPoint, 100);
                  document.getElementById("txtMapLat").value = evt.mapPoint.y;
                  document.getElementById("txtMapLon").value = evt.mapPoint.x;
                  UpdateGraphics()
                  //map.graphics.clear();
                 addGraphic(evt.mapPoint.x, evt.mapPoint.y)
       
      }
 
 
 
 
 
 
    ///// ----------- Start of adding in Malls and Store Points ------////////////
      function UpdateGraphics(layer) {      
        map.graphics.clear();
        map.infoWindow.hide();
             if(dojo.byId("chkMacys").checked){
  				//alert("chkMacys = true");
  				//dojo.byId("Processing")
  				//dijit.byId('Processing').show()
  				queryTaskSelectStores.execute(querySelectStores, showResultsStores);
  				//dijit.byId('Processing').hide()
 
             }
             if(dojo.byId("chkMalls").checked){
  				//alert("chkMalls = true");
  				//dijit.byId('Processing').show()
                //toggleProgressBar()  				
  				queryTaskSelectMalls.execute(querySelectMalls, showResultsMalls);
                //toggleProgressBar()  				
  				//dijit.byId('Processing').hide()
             }   
      }
 
      function showResultsStores(featureSet) {
   		//toggleProgressBar();
		var resultFeatures = featureSet.features;
        for (var i=0, il=resultFeatures.length; i<il; i++) {
          var graphic = resultFeatures[i];
          graphic.setSymbol(symbolStores);
          graphic.setInfoTemplate(infoTemplateStores);
          map.graphics.add(graphic);
        }
    	    //toggleProgressBar();
    }
 
      function showResultsMalls(featureSet) {
		//alert("showResultsMalls")
		//toggleProgressBar()
		var resultFeatures = featureSet.features;
        for (var i=0, il=resultFeatures.length; i<il; i++) {
          var graphic = resultFeatures[i];
          graphic.setSymbol(symbolMalls);
          graphic.setInfoTemplate(infoTemplateMalls);
          map.graphics.add(graphic);
          //dijit.byId('Processing').title = "Processing: " + i
          
        }
        //toggleProgressBar()
      }
 
        function zoom_DMA(){			   	
  			   	var SelectedDMA = dojo.byId("txtEventDMA").value		
  			   	//alert("Selected DMA = " + SelectedDMA); 
     			queryDMA.geometry = null;
   			    queryDMA.where = "DMANAME = '" + SelectedDMA + "'";  			   	
                
   			//Execute the queryTask and call showResults on completion
    			queryDMATask.execute(queryDMA, function(fset) {
   			    //alert("fset.features.length = " + fset.features.length)
  			    if (fset.features.length === 1) { 
     				ZoomMap(fset.features[0],SelectedDMA);
      			    } else{
      			    alert ("No features returned from server.")
                    }
                });
        }
 
        function toggleProgressBar() {
		    var progressbar_container = dojo.byId("progressbar_container");
			var control_panel = dojo.byId("main_panel");
				
			if (progressbar_container.style.display=="block") {
			    progressbar_container.style.display="none";
            }
            else {
                progressbar_container.style.display="block";
            }
        }
 
 
		function ZoomMap(feature, ddValue){
            var fExtent = feature.geometry.getExtent();
			map.setExtent(fExtent);
        }
 
 
 
    function SaveValue_onclick(MallID) {
    //alert("Mall ID: " + MallID)
    dojo.byId("txtMallID").value = MallID;
    dojo.byId("ExistingLocation").Open = 'open';
    dojo.byId("txtMapLat").value = "";
    dojo.byId("txtMapLon").value = "";
    dojo.byId("txtGNAddress").value = "";
    dojo.byId("txtGNCity").value = "";
    dojo.byId("txtGNState").value = "";
    dojo.byId("txtGNZip").value = "";
    dojo.byId("txtGNDMA").value = "";
    dojo.byId("txtGNCounty").value = "";
    dojo.byId("txtGNZip2").value = "";
    
    
    
    
    }
    ///// ----------- End of adding in Malls and Store Points ------////////////
 
 
        ////---- Start of filling in Zip, County and DMA Code----------////
 
      //add points to map and set their symbology + info template
      function addPointsToMap(featureSet) {
        var features = featureSet.features;
        for (var i=0, il=features.length; i<il; i++) {
          map.graphics.add(features[i].setSymbol(defaultSymbol).setInfoTemplate(resultTemplate));
        }
      }
 
 
      function executeQueryGetLocationInformation(evt){
         dijit.byId('Processing').show()
            alert("Processing Request")
 
            ///--- Get ESRI Information ---////
                  locator.locationToAddress(evt.mapPoint, 100);
                  document.getElementById("txtMapLat").value = evt.mapPoint.y;
                  document.getElementById("txtMapLon").value = evt.mapPoint.x;
                  UpdateGraphics()
                  //map.graphics.clear();
                 addGraphic(evt.mapPoint.x, evt.mapPoint.y)
           ///--- Get DMA Information
  			    featureSet = null;
  			    queryDMA.where = null;
  			    queryDMA.geometry = evt.mapPoint;
  			    queryDMATask.execute(queryDMA, GetDMA);           
           ///--- Get ZIP Information
  			    featureSet = null;
  			    queryZip.where = null;
  			    queryZip.geometry = evt.mapPoint;
  			    queryZipTask.execute(queryZip, GetZip);            
           ///--- Get Counties Information
   			    featureSet = null;
  			    queryCounties.where = null;
  			    queryCounties.geometry = evt.mapPoint;
                //If you want to show info window comment out this and uncomment out queryCountiesTask.execute(queryCounties, function(fset) {
                queryCountiesTask.execute(queryCounties, GetCounty);   
                     
                     
          dojo.byId("txtMallID").value = "";                  
          dijit.byId('Processing').hide()
          dialogProcessing('Finished with your Request.....');
      
      }
 
 
 
        function executeQueryDMATask(evt) {
  		//alert("executeQueryDMATask")
  			featureSet = null;
  			queryDMA.where = null;
  			queryDMA.geometry = evt.mapPoint;
  			queryDMATask.execute(queryDMA, GetDMA);
        }
 
      function GetDMA(results) {
          var varDMAName, varDMAID;
//          var s = "";
          //Cannot find any geography in this layer.
          if (results.features.length == 0){
               document.getElementById("txtGNDMAID").value = "00000";
               document.getElementById("txtGNDMA").value = "Not Found"; 	 
          }
//          alert("Number of Results = " + results.features.length)
          for (var i = 0, il = results.features.length; i < il; i++) {
              var featureAttributes = results.features[i].attributes;
              for (att in featureAttributes) {
              //alert("Fields = " + att);
                  try {
 
                      if (att == "DMAID"){
                            //alert("DMAID");
                            varDMAID = featureAttributes[att];
                            document.getElementById("txtGNDMA").value = varDMAID; 	 
                         }                                              
                  } catch (ex) { }
              }
          }
      }
 
 
 
        function UpdateGridViewDetails() {
          //Load updated Details page for event for quick info finder for AR decision maker
             var div = document.getElementById('CompetitiveEvent');
             div.setAttribute("href", "http://ho000xd3840571/CE/CE_GridViewDetails_Plain.aspx?id=" + id);
             //div.hide();
             div.closewindow();
        }
 
 
 
        function executeQueryZipsTask(evt) {
  			featureSet = null;
  			queryZip.where = null;
  			queryZip.geometry = evt.mapPoint;
  			queryZipTask.execute(queryZip, GetZip);
        }
 
 
 
 
      function GetZip(results) {
          var varZip;
          //Cannot find any geography in this layer.
          if (results.features.length == 0){
               document.getElementById("txtGNZip2").value = "00000";                
          }
          for (var i = 0, il = results.features.length; i < il; i++) {
              var featureAttributes = results.features[i].attributes;
              for (att in featureAttributes) {
                  try {
                      if (att == "ZIPCODE"){
                            varZip = featureAttributes[att];
                            document.getElementById("txtGNZip2").value = varZip; 	 
                         }                        
                  } catch (ex) { }
              }
          }
      }
 
 
        function executeQueryCountiesTask(evt) {
  		//alert("Found executeQueryCountiesTask")
  			featureSet = null;
  			queryCounties.where = null;
  			queryCounties.geometry = evt.mapPoint;
 
            //If you want to show info window comment out this and uncomment out queryCountiesTask.execute(queryCounties, function(fset) {
            	    queryCountiesTask.execute(queryCounties, GetCounty);
        }
      function GetCounty(results) {
         var varCountyName, varSTCO;
          //Cannot find any geography in this layer.
          if (results.features.length == 0){
               document.getElementById("txtGNSTCO").value = "00000";                
               document.getElementById("txtGNCounty").value = "Not Found"; 	 
          }
                            ////showInfoWindowCounty(results.features[0], evt);
          for (var i = 0, il = results.features.length; i < il; i++) {
 
              var featureAttributes = results.features[i].attributes;
              for (att in featureAttributes) {
                  try {
                       if (att == "STCO"){
                            varSTCO = featureAttributes[att];
                            document.getElementById("txtGNCounty").value = varSTCO; 	 
                            //Array getting Name 
                         }                        
                  } catch (ex) { }
              }
          }
      }
        ////---- End of filling in Zip, County and DMA Code----------////
 
 
 
 
 
      //add points to map and set their symbology + info template
      function addPointsToMap(featureSet) {
        var features = featureSet.features;
        for (var i=0, il=features.length; i<il; i++) {
          map.graphics.add(features[i].setSymbol(defaultSymbol).setInfoTemplate(resultTemplate));
        }
      }
 
function addGraphic(lon, lat)
{
//	var lon = -95.27654719314574;
//	var lat = 38.95920473022461;
 
	var point = new esri.geometry.Point(lon,lat,map.spatialReference)
	var lineSymbol = new esri.symbol.SimpleLineSymbol(esri.symbol.SimpleLineSymbol.STYLE_SOLID, new dojo.Color([0,0,0]), 2);
	var markerSymbol = new  esri.symbol.SimpleMarkerSymbol(esri.symbol.SimpleMarkerSymbol.STYLE_CIRCLE,10,lineSymbol,new dojo.Color([255,255,0]));
	var graphic = new esri.Graphic(point, markerSymbol, null, null) 
        map.graphics.add(graphic);
}
 
 
      function PopulateAddress(){
            document.getElementById("txtFindAddress").value = "6144 Hunters Green";
            document.getElementById("txtFindState").value = "OH";
            document.getElementById("txtFindZip").value = "45040";
            document.getElementById("txtFindCity").value = "Mason";       
        
      }
      function clearfields(){
      //alert("clear");
            document.getElementById("txtFindAddress").value = "";
            document.getElementById("txtFindState").value = "";
            document.getElementById("txtFindZip").value = "";
            document.getElementById("txtFindCity").value = "";       
      }
      
      function onMapExtentChange(){
        //ZoomOutOnce()
      }
      
      
 
      function ZoomOutOnce(){
                   if (document.getElementById("rdStreetLayer").checked) {
                      // checked. Do this.
                            //alert("Made it to rdStreetLayer")
                         if (map.getLevel() > 14 ){
                            // Zoom out level one time because street layer (transportation) does not have a level 15 view.
                                    //alert("Made it to 14")
                            map.setLevel(map.getLevel()-1);  
                            }                     
                    }
      }
 
 
      function find() {
        //map.graphics.clear();
        locator2 = new esri.tasks.Locator("http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Locators/ESRI_Geocode_USA/GeocodeServer");
        dojo.connect(locator2, "onAddressToLocationsComplete", showResults);
        //alert(dojo.byId("txtFindAddress").value)
        var address2 = {
          Address: dojo.byId("txtFindAddress").value,
          City: dojo.byId("txtFindCity").value,
          State: dojo.byId("txtFindState").value,
          Zip: dojo.byId("txtFindZip").value
        };
            locator2.addressToLocations(address2,["Loc_name"]);
 
 
 
      }
 
 
      function showResults(candidates) {
         //alert("Made it to the start of showResults.")
        var candidate;
        var symbol = new esri.symbol.SimpleMarkerSymbol();
        var infoTemplate = new esri.InfoTemplate("Location", "Address: ${address}<br />Score: ${score}<br />Source locator: ${locatorName}");
 
        symbol.setStyle(esri.symbol.SimpleMarkerSymbol.STYLE_CIRCLE);
        symbol.setColor(new dojo.Color([255,0,0,0.75]));
 
        var points =  new esri.geometry.Multipoint(map.spatialReference);
 
        for (var i=0, il=candidates.length; i<il; i++) {
          candidate = candidates[i];
          if (candidate.score > 20) {
            var attributes = { address:candidate.address, score:candidate.score, locatorName:candidate.attributes.Loc_name };
            var graphic = new esri.Graphic(candidate.location, symbol, attributes, infoTemplate);
            map.graphics.add(graphic);
            //map.graphics.add(new esri.Graphic(candidate.location, new esri.symbol.TextSymbol(attributes.address).setOffset(0, 8)));
            points.addPoint(candidate.location);
                  }
        }
        
        map.setExtent(points.getExtent().expand(3));
 
      }
 
      function extentHistoryChangeHandler() {
        dijit.byId("zoomprev").disabled = navToolbar.isFirstExtent();
        dijit.byId("zoomnext").disabled = navToolbar.isLastExtent();
      }
 
 
 
		//Switch between the basemap layers, or toggle the parcel layer
        function changeMap(layerid) {
  		    var curLayer = map.getLayer(layerid);
  			toggleLayer(curLayer);
  			//ZoomOutOnce();
        }
	        
 
 
		function toggleLayer(layer) {
		//if the layer is visible, turn it off and update the control panel. If invisible, do the same.
         		 //alert("Found Toggle Layer")
  			switch (layer.id)
  			{
  			    case "Imagery":
  				if(dojo.byId("rdImg").Checked){
                    //do nothing
                }
  			    else{
                    if (layer.visible){
                        layer.hide();
  				        map.getLayer("Transportation").show();
  				        dojo.byId("rdStreetLayer").Checked = true;
  				        dojo.byId("rdImg").Checked = false;
                    }
   			        else{
                        layer.show();
   				        map.getLayer("Transportation").hide();
   				        dojo.byId("rdStreetLayer").Checked = false;
   				        dojo.byId("rdImg").Checked = true;
                    }
            }
             
                break;
  			    case "Transportation":
  				if(dojo.byId("rdStreetLayer").Checked){
                    //do nothing
  				}
  				else{
                    if (layer.visible){
                        map.getLayer("Imagery").show();
    				    layer.hide();
                        dojo.byId("rdStreetLayer").Checked = false;
    				    dojo.byId("rdImg").Checked = true;
                    }
    				else{
                        map.getLayer("Imagery").hide();
    				    layer.show();
                        dojo.byId("rdStreetLayer").Checked = true;
    				    dojo.byId("rdImg").Checked = false;
                    }
                }
 
                break;
  			    case "CBSA":
  				var tmpCBSA = dojo.byId("chkCBSA");
  				if (layer.visible){
  				    tmpCBSA.Checked = false;
  				    layer.hide();
                }
                else{
                    tmpCBSA.Checked = true;
  				    layer.show();
                } 
                
                break;
  			    case "Zips":
  				var tmpZips = dojo.byId("chkZips");
  				if (layer.visible){
  				    tmpZips.Checked = false;
  				    layer.hide();
                }
                else{
                    tmpZips.Checked = true;
  				    layer.show();
                } 
 
 
                 break;
  			    case "Counties":
  				var tmpCounties = dojo.byId("chkCounties");
  				if (layer.visible){
  				    tmpCounties.Checked = false;
  				    layer.hide();
                }
                else{
                    tmpCounties.Checked = true;
  				    layer.show();
                }
 
                 break;
  			    case "DMAS":
  				var tmpDMAS = dojo.byId("chkDMAS");
  				if (layer.visible){
  				    tmpDMAS.Checked = false;
  				    layer.hide();
                }
                else{
                    tmpDMAS.Checked = true;
  				    layer.show();
                }
 
  			}
        }
 
//function PostLatLon()
//{ 
//  window.opener.document.forms(0).txtLat.value = document.getElementById("txtMapLat").value;
//  window.opener.document.forms(0).txtLon.value = document.getElementById("txtMapLon").value;
//  window.opener.document.forms(0).selState.value = document.getElementById("txtGNState").value;
//  window.opener.document.forms(0).txtZipCode.value = document.getElementById("txtGNZip").value;
//  window.opener.document.forms(0).txtCity.value = document.getElementById("txtGNCity").value;
 
//  self.close();
//}
 
 
 
 
 
 
		function dialogProcessing(txtTitle, txtContent)
		{
			var thisdialog = new dijit.Dialog({ title: txtTitle, content: txtContent});
			dojo.body().appendChild(thisdialog.domNode);
			thisdialog.startup();
			thisdialog.show();
		}
      dojo.addOnLoad(init);
 
 
		</script>
	</head>
	<body class="tundra"> <!--
      <img id="Img1" height="100" language="javascript" onclick="return Img1_onclick()"
          src="\\ho000xd3840571\CE\images\Macys-Inc-Only.gif" /><img id="AR_Logo" language="javascript"
              onclick="return AR_Logo_onclick()" src="file://\\ho000xd3840571\CE\images\area-research-only.gif" />
      <hr />-->
		<table cellpadding="0" cellspacing="0" style="WIDTH: 1067px">
			<tr>
				<td width="566" style="height: 60px">
					<img src="file://\\ho000xd3840571\CE\images\area-research-only.gif" border="0" style="BORDER-RIGHT:silver 1px solid; BORDER-TOP:silver 1px solid; BORDER-LEFT:silver 1px solid; BORDER-BOTTOM:silver 1px solid">&nbsp;1.4</td>
				<!--    <td style="height: 59px">
        Zoom to District:<br />
    <form action="#" method="GET">
		<input id="progDistrict" />
	</form>
    </td>-->
				<td align="right" width="116" style="height: 60px">
					<span style="FONT-SIZE: 10pt">ID:&nbsp;</span><span style="FONT-SIZE: 10pt"></span>
					<input type="text" name="txtEventID" dojoType="dijit.form.TextBox" trim="true" propercase="true"
						ID="txtEventID" style="WIDTH: 2em">&nbsp;&nbsp;&nbsp;&nbsp;
				</td>
				<td align="right" style="height: 60px">
					<span style="FONT-SIZE: 10pt">DMA:&nbsp;</span>
					<input type="text" name="txtEventDMA" dojoType="dijit.form.TextBox" trim="true" propercase="true"
						ID="txtEventDMA" style="WIDTH: 13.45em">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				</td>
				<td align="right" style="height: 60px">
					<span style="FONT-SIZE: 10pt">Retailer:&nbsp;</span>
					<input type="text" name="txtEventRetailer" dojoType="dijit.form.TextBox" trim="true" propercase="true"
						ID="txtEventRetailer" style="WIDTH: 10em">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				</td>
			</tr>
		</table><input type="hidden" name="txtDMAID" dojoType="dijit.form.TextBox" trim="true" propercase="true"
						ID="txtDMAID" style="WIDTH: 10em"><br>
<!--		<div dojoType="dijit.TitlePane" title="Competitive Event Detail" open="false" id='titlepaneCE'>
			<div dojoType='dijit.layout.ContentPane' id='myContentPane'  duration=1000 href='http://ho000xd3840571/CE/CE_GridViewDetails_plain.aspx?id=60'
				preventCache='true' useCache='false' cacheContent='false'>
				Loading...
			</div>
		</div>-->
 
	    <!-- PROGRESS BAR CONTAINER												-->
 
		<div dojoType="dijit.TitlePane" id="main_panel" title="Map View">
			<table style="width: 1300px">
				<tbody>
					<tr>
						<td style="width: 1386px; height: 0px;">
							<div id="navToolbar" dojoType="dijit.Toolbar">
								      <div dojoType="dijit.form.Button" id="zoomin" onClick="navToolbar.activate(esri.toolbars.Navigation.ZOOM_IN);">Zoom In</div>
          <div dojoType="dijit.form.Button" id="zoomout" onClick="navToolbar.activate(esri.toolbars.Navigation.ZOOM_OUT);">Zoom Out</div>
    
								<div dojoType="dijit.form.Button" id="zoomfullext" onClick="navToolbar.zoomToFullExtent();">Full 
									Extent</div>
								<div dojoType="dijit.form.Button" id="zoomprev" onClick="navToolbar.zoomToPrevExtent();">Prev 
									Extent</div>
								<div dojoType="dijit.form.Button" id="zoomnext" onClick="navToolbar.zoomToNextExtent();">Next 
									Extent</div>
								<div dojoType="dijit.form.Button" id="pan" onClick="navToolbar.activate(esri.toolbars.Navigation.PAN);">Pan</div>
								<div dojoType="dijit.form.Button" id="deactivate" onClick="navToolbar.deactivate()">Deactivate</div>
							</div>
						</td>
					</tr>
					<tr>
						<td style="width: 1386px; height: 560px;">
							<div style="POSITION:relative">
								<div id="map" style="BORDER-RIGHT:#000 1px solid; BORDER-TOP:#000 1px solid; BORDER-LEFT:#000 1px solid; WIDTH:1209px; BORDER-BOTTOM:#000 1px solid; HEIGHT:601px"></div>
								<div style="Z-INDEX:999; RIGHT:5px; POSITION:absolute; TOP:2px">
				<div dojoType="dijit.TitlePane" title="Map layers" open="false" style="WIDTH:400px">
				<a href="#" onclick="dijit.byId('help_dialog').show()" class="right">How it works</a>&nbsp;
										<span><legend><span style="FONT-SIZE: 10pt"></span>Map Layers:</legend>
                          <br>
                          <input id="rdImg" checked name="baseMapGroup" onclick="changeMap(['Imagery']);" type="radio">
                          <label for="rdImg">
                              Satellite Imagery (rdimg)</label><br>
                          <input id="rdStreetLayer" name="baseMapGroup" onclick="changeMap(['Transportation']);"
												type="radio">
                          <label for="rdStreetLayer">
                              Street Layer(rdStreetLayer)</label><br>
                          <hr><input id="chkMacys" name="Macys" type="checkbox" onclick="UpdateGraphics(['Macys'])">
                                            <label for="chkMalls">
                                                <span style="FONT-SIZE: 10pt">Macys Stores</span></label><br />
										</span>
										<input id="chkMalls" name="Malls" type="checkbox" onclick="UpdateGraphics(['Malls'])">
										<label for="chkMalls">
											<span style="FONT-SIZE: 10pt">Malls<br></span>
										</label>
										<input id="chkCBSA" name="Malls" type="checkbox" onClick="changeMap(['CBSA']);" style="FONT-SIZE: 10pt">
										<label for="chkCBSA">
											<span style="FONT-SIZE: 10pt">CBSA<br></span>
										</label>
										<input id="chkZips" name="Zips" type="checkbox" onClick="changeMap(['Zips']);">
										<label for="chkZips">
											<span style="FONT-SIZE: 10pt"> Zips<br></span>
										</label>
										<input id="chkCounties" name="Counties" type="checkbox" onClick="changeMap(['Counties']);">
										<label for="chkCounties">
											<span style="FONT-SIZE: 10pt">Counties<br></span>
										</label>
										<input id="chkDMAS" name="DMAS" type="checkbox" onClick="changeMap(['DMAS']);" value="on">
										<label for="chkDMA">
											<span style="FONT-SIZE: 10pt">DMA</span></label></div>
											
						<div dojoType="dijit.TitlePane" title="Find Address" open="false" style="FONT-SIZE:10pt; WIDTH:400px">
										<span></span><span style="FONT-SIZE: 10pt">&nbsp;Address:&nbsp;&nbsp; &nbsp;</span><input id="txtFindAddress" name="FindAddress" type="text" style="FONT-SIZE: 10pt"><br>
										<span style="FONT-SIZE: 10pt">&nbsp;City: &nbsp;&nbsp; &nbsp;
                                  &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;</span><input id="txtFindCity" name="FindCity" type="text" style="FONT-SIZE: 10pt"><br>
										<span style="FONT-SIZE: 10pt">&nbsp;State &nbsp; &nbsp; &nbsp;
                                  &nbsp;&nbsp; &nbsp;</span><input id="txtFindState" name="FindState" type="text" style="FONT-SIZE: 10pt"><span style="FONT-SIZE: 10pt"><br>
                                  &nbsp;Zip Code:&nbsp; &nbsp;</span><input id="txtFindZip" name="FindZip" type="text" style="FONT-SIZE: 10pt"><span style="FONT-SIZE: 10pt">&nbsp;<br>
                                      &nbsp;</span><input id="btnFind" onclick="find()" style="FONT-SIZE: 10pt; WIDTH: 91px" type="button"
											value="Search"><input id="btnClear" onclick="clearfields()" style="WIDTH: 92px" type="button" value="Clear">
									</div>
									<div dojoType="dijit.TitlePane" id = "ExistingLocation" title="Existing Location" open="false" style="WIDTH:400px">
                                        <input id="txtMallID" name="txtMallID" style="font-size: 10pt" type="text" unselectable="on" /><br />
										<input id="btnSaveExistingLocation" type="button" value="Save Existing  Location"
											style="FONT-SIZE: 10pt; WIDTH: 163px" language="javascript" onclick="return btnSaveExistingLocation_onclick()">
									</div>
									<div dojoType="dijit.TitlePane" title="New Location" open="false" style="WIDTH:400px">
										<span style="FONT-SIZE: 10pt">
     <input id="radAddressLocatorOff" checked="checked" name="AddressLocator" type="radio" language="javascript" onclick="return radAddressLocatorOff_onclick()"/>
      <label for="radAddressLocatorOff">
          Address Locator Off
      </label>
      <input id="radAddressLocatorOn" name="AddressLocator" type="radio" language="javascript" onclick="return radAddressLocatorOn_onclick()"/>
      <label for="radAddressLocatorOn">
          Address Locator On
          <br />
      </label>
            
                        Left click on the map to get location information.<br>
                                            <br />
                        &nbsp;Latititude: &nbsp; </span><input id="txtMapLat" onchange="UpdateAddressFields()" type="text" name="txtMapLat" style="FONT-SIZE: 10pt; WIDTH: 200px" unselectable="on"><span style="FONT-SIZE: 10pt">&nbsp;<br>
                <span>&nbsp;Longitude:</span>
                    &nbsp;</span><input id="txtMapLon" onchange="UpdateAddressFields()" type="text" name="txtMapLon" style="FONT-SIZE: 10pt; WIDTH: 200px" unselectable="on"><span style="FONT-SIZE: 10pt">&nbsp;<br>
                        &nbsp;Address: &nbsp;&nbsp;&nbsp;</span><input id="txtGNAddress" name="txtGNAddress" readonly type="text" style="FONT-SIZE: 10pt; WIDTH: 200px" unselectable="on"><br>
										<span style="FONT-SIZE: 10pt">&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;
                    </span>
										<input id="txtGNCity" readonly type="text" name="txtGNCity" style="FONT-SIZE: 10pt; WIDTH: 77px" unselectable="on">
                                        <input id="txtGNState" readonly type="text" name="txtGNState" style="FONT-SIZE: 10pt; WIDTH: 28px" unselectable="on">
                                        <input id="txtGNZip" readonly type="text" name="txtGNZip" style="FONT-SIZE: 10pt; WIDTH: 49px" unselectable="on"><span style="FONT-SIZE: 10pt">&nbsp;<br>
                        &nbsp;&nbsp;<input id="txtGNDMA" name="txtGNDMA" type="text" style="FONT-SIZE: 10pt; WIDTH: 72px" unselectable="on"><span style="FONT-SIZE: 10pt">&nbsp;
                                          </span>&nbsp; &nbsp;<input id="txtGNCounty" name="txtGNCounty" type="text" style="FONT-SIZE: 10pt; WIDTH: 54px" unselectable="on"><span style="FONT-SIZE: 10pt">&nbsp;
                                              </span>&nbsp;&nbsp;
                                      <input id="txtGNZip2" name="txtGNZip2" type="text" style="FONT-SIZE: 10pt; WIDTH: 72px" unselectable="on"><span style="FONT-SIZE: 10pt"></span>&nbsp;<br>
                      <br>
                      </span>
                                        <input id="btnSaveNewLocation" type="button" value="Save New Location"
											style="FONT-SIZE: 10pt; WIDTH: 138px">
									</div>
</div>
							</div>
						</td>
					</tr>
				</tbody>
			</table>
            <br />
<!--onclick="dijit.byId('help_dialog').show()" -->           
<button dojoType="dijit.form.Button" onclick="dijit.byId('Processing').show()">Bring up help</button>
			<div id="progressbar_container" style="right: 76%; top: 792px; height: 64px;">
       		  <h5>
                     <b>Running Analysis...</b></h5>											
				<div dojoType="dijit.ProgressBar" jsId="jsProgress" id="progressbar" indeterminate="true"></div>
			</div>
            <br />
		</div>
        C:\Inetpub\wwwroot\CE\CE_Post2LDB_2.asp<br>
		C:\Inetpub\wwwroot\CE\Shapefiles\CE_MALLS.shp<br />
        <br />
        <br>
 
 
<div id="CompetitiveEvent" dojoType="dojox.layout.FloatingPane" title="Competitive Event...."
      style="width: 800px; height: 650px; left: 300px; top: 100px; "
       displayMinimizeAction="true"  closable= "false" hasShadow="true" resizable="true" >
</div>
<div id="DMM" dojoType="dojox.layout.FloatingPane" title="Retailer Listing..." 
      style="width: 250px; height: 650px; left: 150; top: 100px; "
       displayMinimizeAction="true"  closable= "false" hasShadow="true" resizable="true" href="http://ho000xd3840571/CE/CE_RetailerFor_CE_Post2LDB.aspx">
</div>
 
<!--http://ho000xd3840571/CE/CE_GridViewDetails.aspx?id=" + id-->
 
<div dojoType="dojox.layout.Dock" id="alternateDock" class="alternateDock"></div>
        <!-- HELP DIALOG BOX													-->
        <div id="help_dialog" dojotype="dijit.Dialog" title="How it works">
            Just testing the help.</div>
        <!-- CLOSES HELP DIALOG BOX 	<!--EndFragment-->
 
        <div id="Processing" dojotype="dijit.Dialog" title="Process....">
            Please be patient while we process your request.</div>
 
 
<script type="text/javascript">
		UpdateGridViewDetails();
function radAddressLocatorOff_onclick() {
                    dojo.disconnect(QueryGetLocationInformation);                    
}
 
function radAddressLocatorOn_onclick() {
                    QueryGetLocationInformation = dojo.connect(map, "onClick", executeQueryGetLocationInformation);          
}
 
 
function btnSaveExistingLocation_onclick() {
// Save to comp events table.
alert("Mall ID: " + dojo.byId("txtMallID").value + "  Event ID: " + dojo.byId("txtEventID").value);
 
	//Create the recordset object
    //var objRS
	//Set objRS = Server.CreateObject("ADODB.Recordset")
	//	objRS.Open "UPDATE Events SET Events.MallID = 999 WHERE (((Events.EventID)=39));","dsn=CompEvents"	
 
 
 
            <% 
            dim strDataPath, strConnectString, objConnection,  objRS, strSelected, strFDSID, strLat, strLon
            dim varMall_ID, varEvent_ID, strsql
            //varMall_ID = Request.Form("txtMallID")
            //varEvent_ID = Request.Form("txtEventID")
            varMall_ID = "39"
            varEvent_ID = "125"
 
            strDataPath = server.MapPath("\Databases\CompEvents.mdb")   
            strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;"_
			            + " Data Source= " & strDataPath & ";"_
			            + " Mode=Share Deny None;User Id=admin;PASSWORD=;"
            			
            			
            if not IsObject("ojbConnection") then
	            set objConnection=Server.CreateObject("ADODB.Connection")
	            objConnection.ConnectionTimeout = 15
	            objConnection.CommandTimeout =  10
	            objConnection.Mode = 3 'adModeReadWrite 
	            if objConnection.State = 0 then
		            objConnection.Open strConnectString
	            end if
            end if
 
            if not isObject("objRS") then
                set objRS=Server.CreateObject("ADODB.RecordSet")
            end if
            //Response.Write(strsql) : Response.End() 
            //strsql = strsql = "UPDATE Events SET Events.MallID = " & varMall_ID & " WHERE (Events.EventID = " & varEvent_ID & ");"
            //strsql = "UPDATE Events SET Events.MallID = 125 WHERE (((Events.EventID)=39));"
            //strsql = "UPDATE Events SET Events.MallID = " &  varMall_ID & " WHERE (((Events.EventID)=" & varEvent_ID & "));"
            strsql = "UPDATE Events SET Events.MallID = " & varMall_ID & " WHERE (Events.EventID = " & varEvent_ID & ");"
            //Response.Write(strsql)
 
                   //'objRS.Open "SELECT MONTHLYOLD.[New Division] FROM MONTHLYOLD WHERE (((MONTHLYOLD.Latitude)<>0) AND ((MONTHLYOLD.Longitude)<>0)) GROUP BY MONTHLYOLD.[New Division] HAVING (((MONTHLYOLD.[New Division])<>''));",objConnection,3,3
                    objRS.Open strsql, objConnection,3,3
 		 	        //objRS.Close
			        set objRS=Nothing
            %>
 
 
 
 
    
}
 
	</script>
	</body>
</html>

Open in new window

flfmmqp

ASKER

Ignore last comment.
If I use this (had Mall_ID and Event_ID numbers mixed up) it works:
varMall_ID = "77"
varEvent_ID = "39"

So I think the problem lies in trying to get the value. I don't think I can use the request.form. How else can I get these values?
varMall_ID = Request.Form("txtMallID")
varEvent_ID = Request.Form("txtEventID")

SOLUTION

ChetOS82

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

flfmmqp

ASKER

Thanks to all for trying to help. I am so close to being done on this project. This is the last step. Can I post the data through the javascript instead of the asp? If so how would I do this. Would this be the better way?

Does not seem to like request either.

ChetOS82

Your input tags are not inside the form tag, try moving the </form> down.

flfmmqp

ASKER

The request does not seem to be worknig either :-(

Since I am able to grab the value from the Java script is there a way to post to the database using javascript?

flfmmqp

ASKER

thanks for your help.