#13763 [Com]: SQL Compute

ID: 13763 Comment by: cyberlovejones@yahoo.com Reported By: alahaye@wanadoo.fr Status: No Feedback Bug Type: Sybase-ct (ctlib) related Operating System: LINUX REDHAT 7 PHP Version: 4.2.1 New Comment: if you are having problems with the compute result set, a workaround would be to create an sql query to generate the same result as the compute would. now you can execute the main query by it self and the "compute or "total" query after it. used a transaction to make sure that data doesn't get changed between the 2 queries. the first statement in the query should be a phantom update. Example begin transaction update employee set name = name where " this should be the same as your next query " select from employee sum(salary), sum(incr) group by ... select * from employee sum(salary), sum(incr) group by .... rollback transaction Previous Comments: ------------------------------------------------------------------------ [2002-12-23 01:00:01] php-bugs@lists.php.net No feedback was provided for this bug for over 2 weeks, 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". ------------------------------------------------------------------------ [2002-12-07 01:40:04] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-05-14 14:36:32] sander@php.net Reopening on user request. ------------------------------------------------------------------------ [2002-05-14 13:50:38] mad@dactar.ch Still needed with 4.2.1 PS : please change status from Bogus to Open ------------------------------------------------------------------------ [2002-04-23 08:41:41] mad@dactar.ch Still needed with 4.2.0 PS : please change status from Bogus to Open ------------------------------------------------------------------------ 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/13763 -- Edit this bug report at http://bugs.php.net/?id=13763&edit=1