static server ResultSet executeSqlWithResult(str _sql)
{
Connection sqlConnection;
Statement sqlStatement;
ResultSet sqlResultSet;
SqlStatementExecutePermission perm;
;
sqlConnection = new Connection();
sqlStatement = sqlConnection.createStatement();
perm = new SqlStatementExecutePermission(_sql);
perm.assert();
sqlResultSet = sqlStatement.executeQuery(_sql);
CodeAccessPermission::revertAssert();
return sqlResultSet;
}
static server int executeSqlStatement(str _sql)
{
Connection sqlConnection;
Statement sqlStatement;
SqlStatementExecutePermission perm;
str sql;
int result;
;
sqlConnection = new Connection();
sqlStatement = sqlConnection.createStatement();
perm = new SqlStatementExecutePermission(_sql);
perm.assert();
result = sqlStatement.executeUpdate(_sql);
CodeAccessPermission::revertAssert();
return result;
strScan (Find a first occurrence of a string in a string) info("int strScan(str _text1,str _text2,int _position,int _number)"); info("Searches a text string for the occurrence of another string."); info("_text1 - The text string to search."); info("_text2 - The string to find."); info("_position - The position at which the search should start."); info("_number - The number of characters that should be searched."); info(int2str(strScan("ABCDEFGHIJ","DE",1,10)));