This is used by subclasses to add extra SQL options to the end of a query.
public static ProcessOptions ( string $p_queryStr, array $p_sqlOptions ) : string | ||
$p_queryStr | string | The current SQL query. |
$p_sqlOptions | array | Available options: 'LIMIT' => [max_rows_to_fetch] 'LIMIT' => array('START'=>[Starting_index],'MAX_ROWS'=>[Max_rows_to_fetch] 'ORDER BY' => [column_name] 'ORDER BY' => array([column_name_1], [column_name_2], ...) 'ORDER BY' => array([column_name_1]=>[ASC|DESC], [column_name_2]=>[ASC|DESC], ...) |
return | string | Original SQL query with the options appended at the end. |