?
Solved

Updating record in a asp page

Posted on 2008-11-06
10
Medium Priority
?
1,283 Views
Last Modified: 2012-05-05
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

0
Comment
Question by:flfmmqp
  • 5
  • 3
  • 2
10 Comments
 
LVL 18

Expert Comment

by:ChetOS82
ID: 22898916
do a Response.Write(strsql) : Response.End() after line 27 and tell me what is displayed.
0
 
LVL 9

Accepted Solution

by:
deathtospam earned 1000 total points
ID: 22899101
I think you might have too many parenthesis in your statement.  Try using this line instead:
strsql = "UPDATE Events SET Events.MallID = " & varMall_ID & " WHERE (Events.EventID = " & varEvent_ID & ");"

Open in new window

0
 
LVL 9

Expert Comment

by:deathtospam
ID: 22899108
Or rather, an extra unpaired parenthesis.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:flfmmqp
ID: 22903805
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

0
 

Author Comment

by:flfmmqp
ID: 22903994
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")
0
 
LVL 18

Assisted Solution

by:ChetOS82
ChetOS82 earned 1000 total points
ID: 22904081
From the looks of your code, you are closing the form tag too soon.  Only one of your input tags are actually inside it.  Or maybe I just don't understand how Dojo works.

Either way, just use Request("txtMaillID") and Request("txtEventID") and see if that works.
0
 

Author Comment

by:flfmmqp
ID: 22904759
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.  
0
 
LVL 18

Expert Comment

by:ChetOS82
ID: 22904774
Your input tags are not inside the form tag, try moving the </form> down.
0
 

Author Comment

by:flfmmqp
ID: 22904782
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?
0
 

Author Closing Comment

by:flfmmqp
ID: 31514082
thanks for your help.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: DanRollins
This article describes a JavaScript program that creates a maze made of hexagonal cells.  In Part 2 (http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/A_7850-Hex-Maze-Part-2.html), we'll extend the program by adding a depth-…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question