From: pavel@templation.net
Operating system: FreeBSD 4.3 RC
PHP version: 4.0.6
PHP Bug Type: Sybase-ct (ctlib) related
Bug description: sybase_query("UPDATE/INSERT") returns FALSE on success
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 bug report at: http://bugs.php.net/?id=13976&edit=1