querywidget

HendrikBritz

Hi All

My Querywidget worked fine but somehow don't anymore. There is something wrong with my sql statement.

I can access the layer via the browser, The one on the right handside works fine.

I get an RPC Fault faultString="Failed to execute query." faultcode="400" faultdetail="" error in flexviewer

Please help

Dont Work

Work

<?xml version="1.0" ?> <configuration>     <layer>http:// ??/arcgis/rest/services/Sasol/SASOL/MapServer/3</layer>     <query>AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI between 30 and 50 </query>     <titlefield></titlefield>     <linkfield/>     <refreshrate/>     <zoomscale/>     <shareresults>false</shareresults>     <orderbyfields></orderbyfields>     <fields all="false">         <field name="AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI" alias="Surf_VCI" />     </fields>     <symbols>     <simplelinesymbol color="0xFF0000" width="5" alpha="0.8" />     </symbols> </configuration>

<?xml version="1.0" ?> <configuration>     <layer>http://??/arcgis/rest/services/Sasol/SASOL/MapServer/3</layer>     <query>AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI &gt; 85</query>     <titlefield></titlefield>     <linkfield/>     <refreshrate/>     <zoomscale/>     <shareresults>false</shareresults>     <orderbyfields></orderbyfields>     <fields all="false">         <field name="AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI" alias="Surf_VCI" />     </fields>     <symbols>     <simplelinesymbol color="0x00FFFF" width="5" alpha="0.8" />     </symbols> </configuration>

RobertScheitlin__GISP

Hennie,

Glad to help. Now it is your turn to help the community by marking this question as answered. All you have to do is click the "Correct Answer" link (the one with the little green star) on the post that provided the answer for you. If the answer was not provided by one of the responders then you can mark any of the replies that you received as helpful by clicking on the "Actions" menu and choosing "Mark as Helpful"