protected function getSQLRelayCursor($sql, $array = null)
{
$cur = sqlrcur_alloc($this->_conn);
if ($array) {
list($sql, $array) = SQLBind::parseSQL($this->_connectionManagement, $sql, $array);
sqlrcur_prepareQuery($cur, $sql);
$bindCount = 1;
foreach ($array as $key => $value) {
$field = strval($bindCount++);
sqlrcur_inputBind($cur, $field, $value);
}
$success = sqlrcur_executeQuery($cur);
sqlrcon_endSession($this->_conn);
} else {
$success = sqlrcur_sendQuery($cur, $sql);
sqlrcon_endSession($this->_conn);
}
if (!$success) {
throw new DatasetException(sqlrcur_errorMessage($cur));
}
sqlrcur_lowerCaseColumnNames($cur);
return $cur;
}
function da_sql_pconnect($config)
{
$retrytime = 0;
if ($config[sql_use_http_credentials] == 'yes') {
global $HTTP_SERVER_VARS;
$SQL_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"];
$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];
} else {
$SQL_user = $config[sql_username];
$SQL_passwd = $config[sql_password];
}
if ($config[sql_connect_timeout] != 0) {
$retrytime = $config[sql_connect_timeout];
}
if ($config[sql_debug] == 'true') {
print "<b>DEBUG(SQL,SQLRELAY DRIVER): Connect: Host={$config['sql_server']},Port={$config['sql_port']},User={$SQL_user},Password={$SQL_passwd} </b><br>\n";
}
$link[con] = sqlrcon_alloc($config[sql_server], $config[sql_port], '', $SQL_user, $SQL_passwd, $retrytime, 1);
if ($link[con]) {
sqlrcon_debugOn($link[con]);
$link[cur] = sqlrcur_alloc($link[con]);
if ($link[cur]) {
sqlrcur_setResultSetBufferSize($link[cur], 4);
sqlrcur_lowerCaseColumnNames($link[cur]);
return $link;
} else {
return false;
}
} else {
return false;
}
}
