Latest Contributions by glennhazelton

yes it is I have called tech support i'll let you know what the answer is after they work it out thanks for responding ... View more

hi Robert, I hope this the right thread. i have been working with your esearch widget for years and i love it. i just moved to the 3.6 version however and i have problem. the 'show results in grid' icon is not visible. how do i get it to show up? thanks glenn hazelton FYI SINCE I POSTED THIS I discovered the reason: I had NOT added the FixedDG to the config file. all is well now. glenn. ... View more

hi could you paste in the txt to excel solution. the link you provided requires logging in and using a credit card. thanks. ... View more

when will the next release be out.? i would like to add photos ... View more

hi again Robert, i have another odd behavior that perhaps you can help me understand. i have an attribute table that has values stored in "double" fieldtypes. in some cases the field is blank and other it is populated with a "0" or "1". if you look at the attached screen shot you will see that in your 'gridview' i see the TC field is  "0" but  the initial search window the field is blank. i also just see blank values in the popup if i click the row in the grid. if i use the regular popup tool (not your esearch) see the "0". any ideas.? ... View more

robert, it turns out that the useUTC tag was implemented at version 2.4 of the viewer. i am a bit slow to move up and am still at 2.31 --thus the tag doesnt work. i will move to 2.5 soon but it takes awhile to migrate all the various widgets. it is nice new features keep being opened but it does mean that there is no stability for us simple users.. thanks again for all your help. Glenn,   Have you tried with the OTB search widget. Because they will not give you supoort for my widget but they will if it does the same in the OTB search widget. ... View more

ok i have put in a help request to ESRI. i will let you know what they figure out.. thanks for your clear and expert help. Glenn, does this code mean that if i have the tag useUTC='true' then i should be getting the time corrected to my timezone.? Yes (that's the way it is suppose to work based on my understanding). how does it know what my timezone is? It (flash Player) gets it from the client machine is it looking at the time on the webserver? No the Client Machine if i dont use the tag then i would get UTC time? Yes (that's the way it is suppose to work based on my understanding). ... View more

So Robert, i could use a bit more explaination-- does this code mean that if i have the tag useUTC='true' then i should be getting the time corrected to my timezone.? how does it know what my timezone is? is it looking at the time on the webserver? and if i dont use the tag then i would get UTC time? here is my config line. it doesnt seem to matter if i have the useUTC in it or not. i see the same results regardless. <field name="THE_DATE" dateformat="MM/DD/YYYY  L A" useUTC="true" gridfield="true"/>  Glenn, Here is the code in my widget and all esri widgets as well that converts the date returned from REST (which is converted to utc before returned):             private function msToDate(ms:Number, dateFormat:String, useUTC:Boolean):String             {                 var date:Date = new Date(ms);                 if (date.milliseconds == 999) // workaround for REST bug                     date.milliseconds++;                 if (useUTC)                     date.minutes += date.timezoneOffset;                                 if (dateFormat){                     dateFormatter.formatString = dateFormat;                     var result:String = dateFormatter.format(date);                     if (result)                         return result;                     else                         return dateFormatter.error;                 }else{                     return date.toLocaleString();                 }             } ... View more

Glen,    What version and service pack of ArcGIS Server are you running? Robert, i am running Arcserver 10 with sp4 installed. it is clear now that what is happening is that Flex is subtracting 5 hrs from the time stored in the DB. the time in the DB is EST or EDT not  GMT. i have tryed a few tags that i found in the flex help (z=EST) or (zzz=GMT-00500) but nothing seem to work make a difference. i am seeing the same results with the Pop-up box as well. http://help.adobe.com/en_US/FlashPlatform/beta/reference/actionscript/3/flash/globalization/DateTimeFormatter.html ... View more

hi Robert, some time ago i asked you for help in formating a date field in the esearch widget. below is what you provided. it works but i am getting odd results. what is occuring is that the dates shown in the datagrid are 24 hrs older that the dates shown in arccatalog or sql+. so i see 5/9/2012 8pm in the esearch datagrid and 5/10/2012 8pm in sql+. i have tryed changing the 'useutc' tag to 'false' and removing it altogether but the displayed results are still the same. do you have ideas about what could be happening? i have attached a screen shot as well. here is the line from the esearch config. <field name="DATE_COLLECTED" dateformat="MM/DD/YYYY  L A" useutc="true" gridfield="true"/ ... View more

yes, as i mentioned i can get greater than and less than code to work. an equal to requires that i have the hh:mm:ss correct, which is a bit hard. i am going to alter the dbase materialized view to make the time 00:00:00 but for now the GT and LT are working and it is a range that i need. <expression alias="GThan DATE" textsearchlabel="Search WWQ by Date Value GreaterThan or Equal to 2012-02-02 00:00:00" field="DATE_TIME_COLLECTED"  usedomain="false"> (DATE_TIME_COLLECTED) &gt;= TO_DATE('[value]','YYYY-MM-DD HH24:MI:SS')</expression> Glen,    If you don't do a date range can you get a single date to work? ... View more

again, thanks for helping. i did as you suggested and used arcmap . i took what i found and build a query to return values with a date less than XXX. it is below. the good news is that it works if i enter a time values like this: 2012-02-02 00:00:00 into the entry box. <expression alias="DATE" textsearchlabel="Search WWQ by Date Value LessThan or Equal to 2012-02-02 00:00:00" field="DATE_TIME_COLLECTED"  usedomain="false"> (DATE_TIME_COLLECTED) &lt;= TO_DATE('[value]','YYYY-MM-DD HH24:MI:SS')</expression> however i still can't get the full SQL that will return records between dates to work. likely it has to do with () or ' ' marks. here is what i put in as code and below that what i attempted to enter into the entry box. any ideas appreciated. <expression alias="Open SQL" textsearchlabel="Search by Typing Full SQL example:[ (DATE_TIME_COLLECTED) &lt;= TO_DATE('2012-02-30 00:00:00','YYYY-MM-DD HH24:MI:SS') AND (DATE_TIME_COLLECTED) &gt;= TO_DATE('2012-01-25 00:00:00','YYYY-MM-DD HH24:MI:SS') ]...">[value]</expression> (DATE_TIME_COLLECTED) &lt;= TO_DATE('2012-02-30 00:00:00','YYYY-MM-DD HH24:MI:SS') AND (DATE_TIME_COLLECTED) &gt;= TO_DATE('2012-01-25 00:00:00','YYYY-MM-DD HH24:MI:SS') Glen,    The easiest way to figure it out is to go to ArcMap and use the Select by attribute query and use the Get Unique Values button to determine the exact format of the date expected. I believe it should look more like this though (I use SQL Server) DATE_TIME_COLLECTED &gt;= '2012-3-1 00:00:00' AND DATE_TIME_COLLECTED &lt;= '2012-2-1 00:00:00' Don't forget to click the top arrow (promote) as shown below on all the posts that have helped: ... View more

thanks Robert, the formatting is working. now i would like to be able to select by date range. i have seen your note about this but i can't make it work. i have tryed a few different ways to type in the date but nothing seems to return any records. here is what i have tryed. i am working against arcSDE in Oracle if the makes a difference. <expression alias="Open SQL" textsearchlabel="Search by Typing Full SQL example:[ DATE_TIME_COLLECTED &gt;= '1/3/2012 00:00:00 AM' AND DATE_TIME_COLLECTED &lt;= '2/1/2012 00:00:00 AM' ]...">[value]</expression> Glen,    Yes you need to set the dateformat and probably the useutc. <field name="SALE_DATE" gridfield="true" dateformat="MM/DD/YYYY" useutc="true"/> ... View more

hi Robert, i am having an issue with displaying a data field. it is coming from Oracle. in the listing window i can see the date just fine as well as in the popup over the feature. however in the datagrid the date is show in its raw state. is there a format tag or something i can use to fix this? thanks. i love this tool. ... View more