Packagecom.ericfeminella.air.cairngorm.business
Classpublic final class SQLStatementHelper

SQLStatementHelper is an all static utility class which provides a mechanism for substituting tokens specified in a raw statement with arbitrary values.



Public Methods
 MethodDefined by
  
create(statement:String, ... args):String
[static] Provides a mechanism allowing substitution of tokens specified in a SQL statement, with an arbitrary list of parameters
SQLStatementHelper
Method detail
create()method
public static function create(statement:String, ... args):String

Provides a mechanism allowing substitution of tokens specified in a SQL statement, with an arbitrary list of parameters

Parameters
statement:String — SQL statement from which tokens are to be replaced
 
... args — arbitrary values to replace the statement tokens

Returns
String — String containing the final SQL statement

Example
The following example demonstrates a typical implementation of by which the tokens {0}, {1}, {2} are substituted with the values 'a', 'b', 'c'
   
   var source:String    = "INSERT INTO 'foo' VALUES('{0}', '{1}') WHERE name='{2}'";
   var statement:String = SQLStatementHelper.create( source, "a", "b", "c" );
   
   trace( statement );
   // INSERT INTO 'foo' VALUES('a', 'b') WHERE name='c'