/**
* Generates an Update Query based on an existing recordset.
* $arrFields is an associative array of fields with the value
* that should be assigned.
*
* Note: This function should only be used on a recordset
* that is run against a single table and sql should only
* be a simple select stmt with no groupby/orderby/limit
*
* "Jonathan Younger" <*****@*****.**>
*/
function GetUpdateSQL(&$rs, $arrFields, $forceUpdate = false, $magicq = false, $force = null)
{
global $ADODB_INCLUDED_LIB;
//********************************************************//
//This is here to maintain compatibility
//with older adodb versions. Sets force type to force nulls if $forcenulls is set.
if (!isset($force)) {
global $ADODB_FORCE_TYPE;
$force = $ADODB_FORCE_TYPE;
}
//********************************************************//
if (empty($ADODB_INCLUDED_LIB)) {
include ADODB_DIR . '/adodb-lib.inc.php';
}
return _adodb_getupdatesql($this, $rs, $arrFields, $forceUpdate, $magicq, $force);
}
/**
* Generates an Update Query based on an existing recordset.
* $arrFields is an associative array of fields with the value
* that should be assigned.
*
* Note: This function should only be used on a recordset
* that is run against a single table and sql should only
* be a simple select stmt with no groupby/orderby/limit
*
* "Jonathan Younger" <*****@*****.**>
*/
function GetUpdateSQL(&$rs, $arrFields, $forceUpdate = false, $magicq = false)
{
global $ADODB_INCLUDED_LIB;
if (empty($ADODB_INCLUDED_LIB)) {
include_once ADODB_DIR . '/adodb-lib.inc.php';
}
return _adodb_getupdatesql($this, $rs, $arrFields, $forceUpdate, $magicq);
}
/**
* Generates an Update Query based on an existing recordset.
* $arrFields is an associative array of fields with the value
* that should be assigned.
*
* Note: This function should only be used on a recordset
* that is run against a single table and sql should only
* be a simple select stmt with no groupby/orderby/limit
*
* "Jonathan Younger" <*****@*****.**>
*/
function GetUpdateSQL(&$rs, $arrFields, $forceUpdate = false, $magicq = false)
{
include_once ADODB_DIR . '/adodb-lib.inc.php';
return _adodb_getupdatesql($this, $rs, $arrFields, $forceUpdate, $magicq);
}
/**
* Generates an Update Query based on an existing recordset.
* $arrFields is an associative array of fields with the value
* that should be assigned.
*
* Note: This function should only be used on a recordset
* that is run against a single table and sql should only
* be a simple select stmt with no groupby/orderby/limit
*
* "Jonathan Younger" <*****@*****.**>
*/
function GetUpdateSQL(&$rs, $arrFields, $forceUpdate = false, $magicq = false, $forcenulls = null)
{
global $ADODB_INCLUDED_LIB;
if (!isset($forcenulls)) {
$forcenulls = defined('ADODB_FORCE_NULLS') ? true : false;
}
if (empty($ADODB_INCLUDED_LIB)) {
include_once ADODB_DIR . '/adodb-lib.inc.php';
}
return _adodb_getupdatesql($this, $rs, $arrFields, $forceUpdate, $magicq, $forcenulls);
}
