Query an External Database
From C3 Wiki
[edit] Summary
Here is a very basic example of setting up an external database connection using ADODB and executing a SQL Query.
This can be very helpful when displaying or refreshing data from external sources.
var conn=WOM.CreateObject("ADODB.Connection");
// this assumes an ODBC system data definition of "Transfer" has been setup
// pointing to the database server
conn.Open( "Transfer");
var rs= WOM.CreateObject("ADODB.recordset");
// put your SQL here, in this sample we return 1 row and all columns in our table
var SQL = "SELECT TOP 1 * FROM myDB.dbo.myTable ";
rs.Open (SQL, conn);
var asList = (rs.EOF) ?null:rs.GetRows();
rs.Close;
conn.Close;
conn = null;
// columns and rows are zero based, so the first row is zero, the first column is zero
var column = 0 ;
var row = 0 ;
var myData = asList.getItem(column,row);
