ID: 28728 Updated by: php-bugs@lists.php.net Reported By: steveh at brendata dot co dot uk -Status: Feedback +Status: No Feedback Bug Type: DBX related Operating System: linux 2.4.22 PHP Version: 4CVS-20041106 New Comment:
No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Previous Comments: ------------------------------------------------------------------------ [2005-02-03 05:34:52] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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
