Bug #13976 Updated: sybase_query("UPDATE/INSERT") returns FALSE on success

ID: 13976 Updated by: sniper Reported By: pavel@templation.net Old Status: Open Status: Closed Bug Type: Sybase-ct (ctlib) related Operating System: FreeBSD 4.3 RC PHP Version: 4.0.6 New Comment: Closed then. Previous Comments: ------------------------------------------------------------------------ [2001-11-08 10:20:42] pavel@templation.net It was probably bug in FreeTDS, at least according to http://franklin.oit.unc.edu/cgi-bin/lyris.pl?visit=freetds&id=163709519 PHP4 with FreeTDS from the current CVS seems to work correctly. ------------------------------------------------------------------------ [2001-11-07 07:58:02] pavel@templation.net if i send UPDATE/INSERT/DELETE query to the script quoted bellow, it will display an empty string as a result of the sybase_query call even if the query was correctly processed. e.g. when i send "delete from testtable", sybase_query returns false, but i can see all records from testtable are deleted. otherwise if i try to send "select" query, i can see something like "Resource id #xx" on success. i'm using php 4.0.6 compiled as an apache's dso, and freetds 0.52 from the freebsd ports collection (php and apache 1.3.22 are also compiled from the freebsd ports collection). test script starts here: <form action="<?php echo $PHP_SELF ?>" method="post"> <textarea name="query" rows="6" cols="50" vrap="virtual"> <?php echo htmlspecialchars($query) ?></textarea> <br><input type="submit" value="submit"> </form> <?php $link = sybase_connect('', 'php', 'xxx'); if (!sybase_select_db('tempdb', $link)) { die("can't use db"); } $res = sybase_query($query, $link); echo "res = $res<br>\n"; ?> ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=13976&edit=1