Here is some example code to access web services in Action Script 2

// Import the Service Library

import mx.services.*;

// define your web service URL, remember to have WDSL at the end

var webService= "http://www.mywebhost.com/webservice/service.asmx?WDSL";

var webService = new mx.services.WebService(webService);
var serviceStatus = true;
webService.onLoad = function (result)
{
    trace("Accessing Web Service: " + company.WebService);
}
;

 

 // to access a method in the web service

 function loadWebMethod() {

    var value1:String = 'test value';

    var value2:Number = 100;

    // set object to use web method called 'MyWebMethod'

    serviceObj = webService.MyWebMethod(value1,value2);

    serviceObj .onStatus = function(status) {
        trace(status);
    };

    serviceObj .onResult = function(result) {
        // Load Current Server Time
        trace(result.toString());
        var xml:XML = new XML();
        xml.ignoreWhite = true;
        xml.parseXML(result.toString());
        ServerTime.Year = xml.firstChild.attributes.year;
    };

    serviceObj .onFault = function(fault) {
        trace("Failed to Load WebService"+fault.faultCode+","+fault.faultstring);
    };
}

 

 

 

USING A CUSROR

DECLARE @FirstName varchar(255), @LastName varchar(255)

DECLARE user_cursor CURSOR FOR

SELECT FirstName,LastName FROM Users

OPEN user_cursor

FETCH NEXT FROM user_cursor

INTO  @FirstName, @LastName

WHILE @@FETCH_STATUS = 0

BEGIN

print @FirstName

FETCH NEXT FROM user_cursor INTO  @FirstName, @LastName

END

CLOSE user_cursor

DEALLOCATE user_cursor

 

USING A TEMPORARY TABLE/VARIABLE

SET NOCOUNT ON
DECLARE @Users TABLE (
 RowID int IDENTITY(1, 1),
 FirstName varchar(255),
 LastName varchar(255)
)

DECLARE @NumberOfRecords int, @RowCount int
DECLARE @FirstName varchar(255)

INSERT INTO @Users(FirstName,LastName)
SELECT FirstName,LastName FROM Users

SET @NumberOfRecords = @@ROWCOUNT
SET @RowCount = 1


WHILE @RowCount <= @NumberOfRecords
BEGIN        

  -- Do Operations

SET @RowCount = @RowCount + 1
END