retreiving data from SQL table

RichardKrell

Problem:
currently I am using the code below to retreive information from a shapefile whenever the user does an Identify (point and click) however they now want to read a SQL database table to retrieve the data and I haven't been able to get it to work using an Infosymbol.

Can anyone point me into a different direction to enable 1. do an identify 2. have a window popup when you select a feature with the data coming back from a SQL table.

    <esri:InfoSymbol id="drcogInfoSymbol">
      <esri:infoRenderer>
        <mx:Component className="infoWindowRenderer"
          xmlns:mx="http://www.adobe.com/2006/mxml">
     
          <mx:VBox backgroundColor="0xEEEEEE">
           <mx:CurrencyFormatter id="infoCurrencyFormatter"
precision="0"
currencySymbol="$"
thousandsSeparatorFrom=","
thousandsSeparatorTo=","
useThousandsSeparator="true"/>

             <mx:HBox width="100%" backgroundColor="0xC6C6C6" height="20" alpha="0.5">
              <mx:Label text="TIP ID:  {data.PROID}" fontWeight="bold"/>
              <mx:Spacer width="100%"/>
             </mx:HBox>
             <mx:Label text="Agency: {data.PROGRAMMIN}"/>
             <mx:Label text="Abbrev. Description:" paddingBottom="0"/>
             <mx:TextArea
              wordWrap="true"
              paddingTop="0"
              width="370"
              borderStyle="none"
              backgroundAlpha="0.0"
              text="{ABBREV_LOC}"/>
             <mx:Label text="Work Being Done: {data.ALL_WORK_T}"/>
             <mx:Label text="Current Funding: {data.MYBONLY}"/>
             <mx:Label text="Completion: {data.COMPLETION}"/>
             <mx:Label text="Type: {data.OVERALL_TY}"/>
             <mx:Label text="ARRA: {data.MODELED}"/>
             <mx:Label text="Contact: {data.CONTACT}"/>
             <mx:Label text="Contact At: {data.CONTACT_AT}"/>
             <mx:Label text="Total Cost: {infoCurrencyFormatter.format(data.TOTAL_COST)}"/>
          </mx:VBox>
        </mx:Component>
      </esri:infoRenderer>
    </esri:InfoSymbol>

NasifAlshaier

Hi Richard.

were yu able to get the retrieve dat from SQL working?
please advise.
nia@miamidade.gov