SQVAR

Used in

Servers

Parent elements

Syntax

<SQVAR	Attribute Description Table
name="[%var%]" position="nonnegative value" > (r)<FIELD... /> </SQVAR >
(r): Attribute or child element is required.

Description

Defines a position of the query field in the where expression of the query element.

Restrictions

ArcIMS Java Viewers and ArcExplorer-Java Edition are limited to one variable. HTML Viewers can have multiple variables.

Attribute Descriptions for SQVAR

Attribute	Usage
name	Defines string used for the variable name.
position	Defines the location in the string of the opening bracket "[" in the variable expression. The value should be equal to or less than the position in the string where the bracket is located. If "'" is used in the expression, this is counted as one character.

Examples for SQVAR

<?xml version="1.0" encoding="UTF-8"?>
<ARCXML version="1.1">
  <CONFIG>
    <ENVIRONMENT>
      <LOCALE country="US" language="en" variant="" />
      <UIFONT color="0,0,0" name="Arial" size="12" style="regular" />
      <SCREEN dpi="96" />
    </ENVIRONMENT>
    <MAP>
      <PROPERTIES>
        <ENVELOPE minx="-141.0030059814453" miny="41.9133186340332" maxx="-52.62028121948242" maxy="83.10832214355469" name="Initial_Extent" />
        <MAPUNITS units="decimal_degrees" />
        <FILTERCOORDSYS id="4326" />
        <FEATURECOORDSYS id="4326"/>
      </PROPERTIES>
      <WORKSPACES>
        <SHAPEWORKSPACE name="shp_ws-0" directory="<path to CANADA ESRIDATA>" />
      </WORKSPACES>
      <LAYER type="featureclass" name="province" visible="true" id="0">
        <DATASET name="province" type="polygon" workspace="shp_ws-0" />
        <SIMPLERENDERER>
          <SIMPLEPOLYGONSYMBOL filltransparency="1.0" fillcolor="127,127,127" />
        </SIMPLERENDERER>
        <EXTENSION type="StoredQuery">
          <STOREDQUERIES>
            <STOREDQUERY name="Provinces">
              <QUERY where="( NAME = '[%var%]' )" subfields="#SHAPE# AREA CODE NAME POP1991 POP91_SQMI" />
              <SQVAR position="0" name="[%var%]">
                <FIELD name="NAME" precision="0" type="12" size="25" />
              </SQVAR>
            </STOREDQUERY>
          </STOREDQUERIES>
      </EXTENSION>
      </LAYER>
    </MAP>
  </CONFIG>
</ARCXML>