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'