Connect a Database with Macromedia Flash Remoting MX Using SSAS

The server-side ActionScript (SSAS) in Listing E.12 connects to a Flash Remoting MX service to perform a simple user login authentication. The service is defined when the application starts. A Service method is called and handled when the client connects. Remember, Flash Remoting MX is nonpersistent. A connection is established each time a service method is invoked.

Listing E.12 Server-Side ActionScript for Connecting a Database with Flash Remoting MX

 // Load the NetServices Class Libraries load("netservices.asc"); // When the application Starts, setup the non-persistent Flash Remoting server application.onAppStart = function() {       trace("Application was loaded, Cap'n");       NetServices.setDefaultGatewayUrl("http://localhost/flashservices/gateway");       var gatewayConnection = NetServices.createGatewayConnection();       //  instantiate the service into a local variable       var cf_service = gatewayConnection.getService ("myFlashComService.login_service",  this); }; application.onConnect = function(clientObject, username, password) {       // call the server function, authenticateUser, passing the username and password       var callTheServer = cf_service.authenticateUser(username, password);       // handle the server response       this.authenticateUser_Result = function(result_rs) {             trace("The Server Responded  > "+ result_rs.getLength());             trace("The firstName value of row 0  > "+ result_rs.items[0].firstName);             };       // handle any server errors       this.authenticateUser_Status = function(status) {             trace("Returned FAILED From the Server");       }; };