Description: ------------ After executing $db->excute() with parameterized query, output from fread() is truncated to 8192 bytes. Works fine with no placeholder/parameter. MDB2 2.3.0 MDB2_Driver_mssql 1.1.0 Test script: --------------- <?php require_once "MDB2.php"; $fh = fopen('bigfile.txt', 'r'); $contents = fread($fh, filesize('bigfile.txt')); print "Contents = " . strlen($contents) . "\n"; $dsn = "mssql://user:passwd@server/db"; $dbh = MDB2::factory($dsn); $query = "select * from sysobjects where name like ?"; $sth = $dbh->prepare($query); $res = $sth->execute('A%'); $fh = fopen('bigfile.txt', 'r'); $contents = fread($fh, filesize('bigfile.txt')); print "Contents = " . strlen($contents) . "\n"; ?> Expected result: ---------------- Contents = 10000 Contents = 10000 Actual result: -------------- Contents = 10000 Contents = 8192

Those two versions are probably just out of sync with each other. Please try MDB2 2.1.0 .. or update the mssql driver from CVS.

Blair, have you tried CVS ? If it's fixed, i'll make the release within the next few days. Thanks

David, what exactly should I get from cvs? Would you post the cvs commands?

Try downloading the files from cvs there: http://cvs.php.net/viewvc.cgi/pear/MDB2/MDB2/Driver/ the mssql.php and in all directories the mssql.php files and replace them with your include_path MDB2/Driver files. You should see the pattern pretty easily once you get the files. Let me know if you need more help getting the files and if by changing those, it fixed your problem. Thanks :-)

Actually Blair, you can try to just do pear upgrade MDB2_Driver_mssql-1.1.2 And then let me know if this version fixes your problems. Thanks, David

Thanks, David. Installed MDB2_Driver_mssql-1.1.2, but still have the same problem. Perhaps it's FreeTDS. Is there a way to run a placeholder query using PHP's mssql functions?

Yep, just look at the MDB2 documentation for prepare and you should get a good idea. I will mark this bug as bogus as it seems to be something unrelated and I cannot reproduce. If you can make it work with custom placeholders, just let me know too please :) Thanks