php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #13976 sybase_query("UPDATE/INSERT") returns FALSE on success
Submitted: 2001-11-07 07:58 UTC Modified: 2001-11-09 10:03 UTC
From: pavel at templation dot net Assigned:
Status: Closed Package: Sybase-ct (ctlib) related
PHP Version: 4.0.6 OS: FreeBSD 4.3 RC
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: pavel at templation dot net
New email:
PHP Version: OS:

 

 [2001-11-07 07:58 UTC] pavel at templation dot 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";

?>

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-11-08 10:20 UTC] pavel at templation dot 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-09 10:03 UTC] sniper@php.net
Closed then.

 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Tue Jun 22 19:01:23 2021 UTC