note 43042 added to function.mssql-execute

<?PHP /*This functions will help you to get SQLTYPES direct from systypes and you can associate them with PHPSQLTYPES. */ /* <font color="#007f00">Associete PHP types with systypes..xtypes, see <b>mssql_get_types()</b> </font>*/ if(!defined('dbMSSQL_Types')) { define('dbMSSqlTypes',1); $MSSQL_types[127] = SQLINT4; /* bigint*/ $MSSQL_types[104] = SQLBIT; /* bit*/ $MSSQL_types[175] = SQLCHAR; /* char*/ $MSSQL_types[56] = SQLINT2; /* int*/ $MSSQL_types[52] = SQLINT2; /* smallint*/ $MSSQL_types[35] = SQLTEXT; /* text*/ $MSSQL_types[48] = SQLINT1; /* tinyint*/ $MSSQL_types[167] = SQLVARCHAR; /* varchar*/ $MSSQL_types[62] = SQLFLT8; /* float*/ $MSSQL_types[173] = SQLVARCHAR; /* binary*/ // Adaptation $MSSQL_types[61] = SQLINT4; /* datetime*/ // Adaptation $MSSQL_types[106] = SQLFLT8; /* decimal*/ // Adaptation $MSSQL_types[34] = SQLVARCHAR; /* image*/ // Adaptation $MSSQL_types[60] = SQLFLT8; /* money*/ // Adaptation $MSSQL_types[239] = SQLCHAR; /* nchar*/ // Adaptation $MSSQL_types[99] = SQLTEXT; /* ntext*/ // Adaptation $MSSQL_types[108] = SQLFLT8; /* numeric*/ // Adaptation $MSSQL_types[231] = SQLVARCHAR; /* nvarchar*/ // Adaptation $MSSQL_types[59] = SQLFLT8; /* real*/ // Adaptation $MSSQL_types[58] = SQLINT4; /* smalldatetime*/ // Adaptation $MSSQL_types[122] = SQLFLT8; /* smallmoney*/ // Adaptation $MSSQL_types[98] = SQLVARCHAR; /* sql_variant*/ // Adaptation $MSSQL_types[189] = SQLINT4; /* timestamp*/ // Adaptation $MSSQL_types[165] = SQLVARCHAR; /* varbinary*/ // Adaptation } /* <font color="#007f00">Gets current connection systypes and shows this: $MSSQL_types[systypes..xtype] = PutPHPSqlTypeHere // Name_in_systypes // </font>*/ function mssql_get_types(){ $res = mssql_query('select name,xtype from systypes'); echo('<pre><CODE>'); while(($val = mssql_fetch_assoc($res))){ echo('$MSSQL_types['.$val['xtype']."]\t= ;\t/* ".$val['name']." */\n"); } print_r(phpinfo(INFO_VARIABLES)); echo('</CODE></pre>'); } ?> ---- Manual Page -- http://www.php.net/manual/en/function.mssql-execute.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+43042 Delete -- http://master.php.net/manage/user-notes.php?action=delete+43042&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+43042&report=yes Search -- http://master.php.net/manage/user-notes.php