ID: 28728 Updated by: [EMAIL PROTECTED] Reported By: steveh at brendata dot co dot uk -Status: Open +Status: Feedback Bug Type: DBX related Operating System: linux 2.4.22 PHP Version: 4CVS-20041106 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2004-06-14 12:55:05] steveh at brendata dot co dot uk Ok, I've upgraded freetds to 0.62.4 >From the SQL Profiler I can see that the use and the select is being executed on the SQL server. I've successfully run tests using the tsql utility provided with freetds, I'm now at a bit of a loss as to what else to test, it looks like a fairly basic failure? The major difference is that this server is sql2000, whereas our production bugs server is sql6.5(!) ------------------------------------------------------------------------ [2004-06-14 12:16:49] steveh at brendata dot co dot uk Here's code that reproduces the issue along with the definition of the table (the table is currently empty). <?php function zsql_query($Sql) { $Link=dbx_connect(DBX_SYBASECT, "SALESTRACK", "SalesTracking", "sa", "password", DBX_PERSISTENT); $Result=dbx_query($Link,$Sql); dbx_close($Link); Return $Result; } function zdropdown($Variable,$QueryString,$Selected,$ExtraName="",$ExtraValue="",$SortColumn=2) { $Ret=""; $Result=zsql_query($QueryString." order by $SortColumn asc"); return $Ret; } echo zdropdown("dCM__DefaultInvoice_tblAddressID","select ID,Name from tblAddress",$dCM__DefaultInvoice_tblAddressID," ",-1); ?> I'm going to run some tests on freetds to make sure this isn't a freetds bug. ------------------------------------------------------------------------ [2004-06-11 12:21:52] [EMAIL PROTECTED] keep in feedback status until you've given proper feedback. ------------------------------------------------------------------------ [2004-06-11 11:14:33] steveh at brendata dot co dot uk Sybasect is fine as we're using it directly in our bug tracking system, this is the only system that uses dbx, producing sample code could be difficult, I'll see if I can strip it down to the really basic parts. ------------------------------------------------------------------------ [2004-06-11 10:50:50] [EMAIL PROTECTED] Can you check if using the sybasect ext directly doesn't have this problem? And can you provide some sample code? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/28728 -- Edit this bug report at http://bugs.php.net/?id=28728&edit=1
