Bug #13976 Updated: sybase_query("UPDATE/INSERT") returns FALSE on success
ID: 13976
User updated by: pavel@templation.net
Reported By: pavel@templation.net
Status: Open
Bug Type: Sybase-ct (ctlib) related
Operating System: FreeBSD 4.3 RC
PHP Version: 4.0.6
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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
Thread (3 messages)