Jay,I am not sure what kind of data you are trying to consume in the service, I only wanted to publish data in 5 sql tables. So I added the tables to ArcMap, did a join by attribute to my parcel data, then published the MXD as a web service in ArcServer. I looked into creating a .net webservice, I also have no experience with .net, and it was easier to do it in ArcMap. I then used the ArcServer Flex API to run queries against the webservice. I have no need to access any of the spatial data, also in ArcServer 10 you can add tables to an MXD and publish them in a webservice and they show up like layers. I did it all in ArcServer 9.3.1, showing is my query function on my webservice //query function
private function doQuery():void
{
if (streetName.text == "")
{
Alert.show("Please Enter Text", "User Error");
}
else
{
progressBar.visible = true;
var query:Query = new Query();
var pExpr:String = streetName.text.toUpperCase();
pExpr = pExpr.replace(",","");
pExpr = pExpr.replace("-","");
pExpr = pExpr.replace(".","");
var expr:String = queryExpr.replace("[value]", pExpr)
query.where = expr;
query.outFields = ["*"]
query.returnGeometry = false;
queryTask.execute(query, new AsyncResponder(onResult, onFault));
function onResult(featureSet:FeatureSet, token:Object = null):void
{
progressBar.visible = false;
}
function onFault(info:Object, token:Object = null):void
{
progressBar.visible = false;
Alert.show("No parcels were found", "Try something else");
}
}
//enable radion buttons to switch
private function changesearch(event:ItemClickEvent):void
{
switch(event.label.toLowerCase())
{
case "street":
{
txtLabelText.text = "Search Parcels by Street Name ex. Park Pl"
queryExpr = "LocAddr LIKE '%[value]%'";
autoCompleteMgr.enabled = true;
break;
}
case "owner":
{
txtLabelText.text = "Search Parcels by Owner Name (Last Name First) ex. Smith John"
queryExpr = "Owner1 LIKE '%[value]%'";
autoCompleteMgr.enabled = false;
break;
}
}
}
}
