note 43043 added to function.mssql-execute
| From: | marco dot carvalho at NOSPAM dot uni-yoga dot org dot br | Date: | Mon, 07 Jun 2004 18:00:55 +0000 |
| Subject: | note 43043 added to function.mssql-execute | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-70734@lists.php.net to get a copy of this message | ||
<?PHP
/*
<font color="#007f00">
Gets all fields properties from table/stored procedure in <i>systables</i> and stores
in <b>$GLOBALS['MSSQL_PROP_'.$object]</b><br>
Returns: <b>True</b> or <b>false</b>
</font>
*/
function mssql_get_all_fields_properties($object){
$res=mssql_query("select colorder,name,xtype,length,xprec from syscolumns where id =
object_id('$object')");
if($res){
while(($tmp = mssql_fetch_assoc($res))){
$ret[$tmp['colorder']] = $tmp;
}
$GLOBALS['MSSQL_PROP_'.$object] = $ret;
return true;
}
else return false;
}
/*
<font color="#007f00">
Gets <b>$field</b> properties from <b>$object</b> table/stored procedure in
<i>systables</i> and stores
in <b>$GLOBALS['MSSQL_PROP_'.$object]</b><br>
Returns: <b>Array of properties</b> or <b>false</b> if some error occured.
</font>
*/
function mssql_get_field_properties($object,$field)
{
if(!isset($GLOBALS['MSSQL_PROP_'.$object]) )
if(!mssql_get_all_fields_properties($object))
return false;
foreach($GLOBALS['MSSQL_PROP_'.$object] as $prop){
if($prop['name'] == $field) return $prop;
}
}
/*
<font color="#007f00">
Gets <b>$field</b> length from <b>$object</b> table/stored procedure in
<i>systables</i> and stores
in <b>$GLOBALS['MSSQL_PROP_'.$object]</b><br>
Returns: <b>length</b> or <b>false</b> if some error occured.
</font>
*/
function mssql_get_field_length($object,$field)
{
if(!isset($GLOBALS['MSSQL_PROP_'.$object]) )
if(!mssql_get_all_fields_properties($object))
return false;
foreach($GLOBALS['MSSQL_PROP_'.$object] as $prop){
if($prop['name'] == $field) return $prop['length'];
}
}
/*
<font color="#007f00">
Gets <b>$field</b> xprec from <b>$object</b> table/stored procedure in
<i>systables</i> and stores
in <b>$GLOBALS['MSSQL_PROP_'.$object]</b><br>
Returns: <b>length</b> or <b>false</b> if some error occured.
</font>
*/
function mssql_get_field_length($object,$field)
{
if(!isset($GLOBALS['MSSQL_PROP_'.$object]) )
if(!mssql_get_all_fields_properties($object))
return false;
foreach($GLOBALS['MSSQL_PROP_'.$object] as $prop){
if($prop['name'] == $field) return $prop['xprec'];
}
}
/*
<font color="#007f00">
Gets <b>$field</b> xprec from <b>$object</b> table/stored procedure in
<i>systables</i> and stores
in <b>$GLOBALS['MSSQL_PROP_'.$object]</b><br>
Returns: <b>length</b> or <b>false</b> if some error occured.
</font>
*/
function mssql_get_field_colorder($object,$field)
{
if(!isset($GLOBALS['MSSQL_PROP_'.$object]) )
if(!mssql_get_all_fields_properties($object))
return false;
foreach($GLOBALS['MSSQL_PROP_'.$object] as $prop){
if($prop['name'] == $field) return $prop['colorder'];
}
}
?>
----
Manual Page -- http://www.php.net/manual/en/function.mssql-execute.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+43043
Delete -- http://master.php.net/manage/user-notes.php?action=delete+43043&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+43043&report=yes
Search -- http://master.php.net/manage/user-notes.php