ID: 12348
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MSSQL related
Operating System: linux 7.1
PHP Version: 4.0.6
New Comment:
Please notice that the FreeTDS stuff might be broken for SQL Server 2000 and up.
Previous Comments:
------------------------------------------------------------------------
[2001-07-24 18:37:30] [EMAIL PROTECTED]
We do have a patch that you can roll out in your next release i will send in soon
after removing junk comments.
------------------------------------------------------------------------
[2001-07-24 17:18:13] [EMAIL PROTECTED]
please send your patch (when you are done) to
[EMAIL PROTECTED]
------------------------------------------------------------------------
[2001-07-24 16:45:26] [EMAIL PROTECTED]
the issue is i am using the sybase C files and the function is for the mssql C files.
I am working with a coworker to rewrite the sybase C files to support the
mssql_next_result function. If you have a version that does please let me know and if
we get this to work i will give you the C files for the next release.
// error
Fatal error: Call to undefined function: mssql_next_result() in
/usr/local/apache/htdocs/reporting/reports/rpttrafficdetailsbycpc.dll on line 12
------------------------------------------------------------------------
[2001-07-24 14:26:35] [EMAIL PROTECTED]
could you post the exact error message, or put the script
on the internet so I can view it.
------------------------------------------------------------------------
[2001-07-24 14:24:14] [EMAIL PROTECTED]
<?
if (connect_db($ip, $db)) {
$q = "exec $sp @date='$date'";
$results = mssql_query($q);
$max = mssql_num_fields($results);
for ($f=0; $f < $max; $f++) {
$name = mssql_fetch_field($results, $f);
print $name->name ."<br>";
}
// this is the problem ??? the sp has 2 result sets
// i am trying to get to the second set.
mssql_next_result($results);
}
?>
// config line
./configure \
--with-mysql \
--with-mhash \
--with-sybase=/usr/local/freetds \
--with-apache=../apache_1.3.20 \
--enable-versioning \
--disable-debug \
--enable-debug=no \
--enable-sigchild \
--enable-calendar \
--enable-trans-sid \
--disable-xml
// other info
i am runnong freetds v.0.51 connecting to sql2000
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=12348&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
