// ActionScript file

import fourD.sql.*;
import flash.external.*;
import mx.controls.Alert;
import mx.rpc.events.FaultEvent;
import mx.rpc.events.ResultEvent;
import mx.controls.Alert;

[Bindable]
private var _resultSet:SQLResultSet;
[Bindable]
private var uidVar:String;

// Get ID with JavaScript
private function initID():void
{
    _resultSet = null;
    uidVar = ExternalInterface.call("getURLVars", "id");
    Alert.show(uidVar);
    fourDSQLService.connect();
}

// Initialize the connection
private function connectHandler(event:Event):void 
{
    // Send SQL query to the 4D SQL server
    fourDSQLService.execute("SELECT * FROM contact"); 
} 
            
    // Receive the result from the 4D SQL server
private function resultHandler(event:ResultEvent):void 
{
    // Fill resultset
    if(event.result != null) { _resultSet = event.result as SQLResultSet; } 
} 

// Actions to perform in case of errors
private function faultHandler(event:FaultEvent):void 
{
    var zeError:String= "Error #" + event.fault.faultCode;
    // Display errors
    Alert.show(event.fault.faultString,zeError); 
}