public function FrxMSSQL::sqlData in Forena Reports 7.4
Same name and namespace in other branches
- 7.3 plugins/FrxMSSQL.inc \FrxMSSQL::sqlData()
Get data based on file data block in the repository.
Parameters
String $block_name:
Array $parm_data:
Query $subQuery:
Overrides FrxDataSource::sqlData
File
- plugins/
FrxMSSQL.inc, line 65 - Oracle specific driver that takes advantage of oracles native XML support
Class
- FrxMSSQL
- @file Oracle specific driver that takes advantage of oracles native XML support
Code
public function sqlData($sql, $options = array()) {
// Load the block from the file
$db = $this->db;
// Load the types array based on data
$this->types = isset($options['type']) ? $options['type'] : array();
$xml = '';
// Load the types array based on data
$this->types = isset($options['type']) ? $options['type'] : array();
if ($sql && $db) {
$sql = $this->te
->replace($sql);
if ($this->use_mssql_xml) {
$xml = $this
->mssql_xml($sql, 'table');
}
else {
$xml = $this
->php_xml($sql);
}
if ($this->debug) {
if ($xml) {
$d = htmlspecialchars($xml
->asXML());
}
FRx::debug('SQL: ' . $sql, '<pre> SQL:' . $sql . "\n XML: " . $d . "\n</pre>");
}
return $xml;
}
}