Latest Contributions by Gabriel_J_Ortiz_Rico

ArcGIS Server 10.0 and in that server I have applied only SP3 ... View more

Yes, Robert, all the fields are numeric. I did test with the space and without space, and always get the same error. In fact, the expression works with and without the refered space before the AND operators whenever the fields involved are type double. When I include the search in a LONG INTEGER is when I get the error. If I have 4 fields: municipio (long integer), poligono (double), parcela (double), recinto (double). All my expressions work perfectly with all the conbinations of the double fields. Several multifield searches works without problems. However, the simplest expression across the long integer field produces the error (even if isn't a multifield expression). That is, it works perfectly until I include a long integer field. I will do more testing but I am running out of options... ... View more

I get this error: error #1009 when trying to search with this expression: <expression alias="Polígono, Parcela, Recinto" textsearchlabel=""> <values>     <value prompt="Polígono: (ej. 19)">POLIGONO = [value]</value> </values> <values>    <value prompt="Parcela: (ej. 111)">AND PARCELA = [value]</value> </values> <values>    <value prompt="Recinto: (ej. 9)">AND RECINTO = [value]</value> </values> </expression> Please note that all the fields are numeric. I also tried a simpler search expressión with only one condition: <expression alias="Polígono, Parcela, Recinto" textsearchlabel=""> <values>    <value prompt="Polígono: (ej. 19)">POLIGONO = [value]</value> </values> </expression> The result was the same: error #1009. No matter if you populate all the textboxes or not. Always get error. I also saw a different behaviour depending of the data type of numeric fields. In the case of the simple expression POLIGONO = [value] if the field is Long Integer I get this error: [RPC Fault faultString="Unable to complete operation." faultCode="400" faultDetal="Unable to complete Query operation."] However, if the field is type Double, the search is executed without problems. Is someone else finding this problems with this numeric data types? Thanks for your help. ... View more

Thank you Robert. The problem is that in spite that you define the SQL statement in the XML, there are a number of techniques to append another actions to such predefined SQL by the use of different characters (one of the most resourceful is the use of ; ) This is the basis of the SQL injections, actually. My asking perhaps should have to be diverted to another part of the forums, but it is interesting to consider this aspect. With this new technology we often expose information led by the huge possibilities and often we don't give a thought to the hidden hazards. ... View more

Robert, you can't imagine the HUGE apportation you have done to the ArcGIS Server users community. Thank you for your dedication and for all your expertise. Thank you!! Thank you!!! Thank you!!! Your work is great!!! I would like to comment you one small bug and also ask you three questions: Possible bug: There is a customizable parameter that the widget is not interpreting properly (at least in 3.0.5 and I think in 3.0.6 is not corrected...) In spite of setting the nobufferoutlinecolor to: <nobufferoutlinecolor>Sin Color</nobufferoutlinecolor>, the widget shows the default label (No outline color). And the questions: 1/. Is possible to limit the width of the text input box in an expression? I mean... the input text box in an search expression spans from one end of the widget window to the other, and I would like to put two search conditions IN ONE LINE, in order to have all 4 search conditions at view in the widget, so that the user does not have to scroll down. If this is not possible, would it be possible to control the height and width of the widget window? (maybe this is documented, but I didn't find out how). 2/. If I have 4 search criteria within one search expression, is it possible to leave blank one of the search criteria and execute anyway the search as if it was populated? It would be like using a wildcard (% ? *). In my application the user has to execute a query using 4 criteria what should be transformed in a WHERE parameter1='a' AND parameter2='b' AND parameter3='c' AND parameter4='d'. What I want to do is to execute this query even if there is no value in the parameter3 or parameter4 (that is, selecting any value in parameter3 and in parameter4). 3/. The third question is about security. I suppose that all the SQL sequences commited through the widget use the REST or SOAP exposed services which, I suppose, are cleaning and sanitizing every SQL sentence before executing it in the backend. I know that this matter is related more with the whole ArcGIS Server environment rather than with the widget, but if you or others could talk a little bit about this subject it would be great. Thanks again for sharing with the community. ... View more

No, I didn't. The metadata functionality in ArcGIS is far, far away to be up to standards. But this doesn't seem to worry to ESRI... It's incredible that even in 10.1 this issue is unresolved yet. ... View more

Yes, we did. In our case it turned out to be a misconfiguration of the drivers and software of the storage (SAN). For some reason, the storage network failed when reading large amounts of data and big files. When we tried to do a normal backup from SQL Server (even without SDE intervention), we realized that similar errors appeared in the events registry of the operating system and in the registry of SQL Server, so we began to look in another direction (something related with the operating system actually). Best regards. ... View more