[PHP-DEV] Bug #14354 Updated: sybase_query returns 1 regardless of delete success
ID: 14354 Updated by: lobbin Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 8 Old PHP Version: 4.0.6 PHP Version: 4.1.1 Previous Comments: [2002-01-08 17:02:43] [EMAIL PROTECTED] I just tried it on php 4.1.1 and the problem still exists. [2002-01-07 02:34:06] [EMAIL PROTECTED] Does this problem still exist on 4.1.1? [2001-12-12 06:41:44] [EMAIL PROTECTED] oh, ok, then it is not bogus. [2001-12-12 06:24:21] [EMAIL PROTECTED] I'm not sure if I can agree with you on that. If I don't use the @ sign, sybase_query displays a warning of the type Warning: Sybase message: Children still exist in 'table1'. Cannot delete parent 'table2'. (severity 16) in /path/to/my/script.php on line 1432 Doesn't that mean that sybase_query didn't return ok? Besides, according to the documentation, the function sybase_affected_rows is only implemented for the ct library, not dblib. Unfortunately, we haven't been able to get sybase-ct to work for us, even though we tried all the hints we could get. [2001-12-11 13:58:59] [EMAIL PROTECTED] Actually, this is not a bug. The query still executes ok, but the result is different then you want. You can check with the sybase_affected_rows function if it is deleted or not: www.php.net/sybase_affected_rows Derick 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/?id=14354 Edit this bug report at http://bugs.php.net/?id=14354edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #14354 Updated: sybase_query returns 1 regardless of delete success
ID: 14354 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Old Status: Feedback Status: Open Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 8 PHP Version: 4.0.6 New Comment: I just tried it on php 4.1.1 and the problem still exists. Previous Comments: [2002-01-07 02:34:06] [EMAIL PROTECTED] Does this problem still exist on 4.1.1? [2001-12-12 06:41:44] [EMAIL PROTECTED] oh, ok, then it is not bogus. [2001-12-12 06:24:21] [EMAIL PROTECTED] I'm not sure if I can agree with you on that. If I don't use the @ sign, sybase_query displays a warning of the type Warning: Sybase message: Children still exist in 'table1'. Cannot delete parent 'table2'. (severity 16) in /path/to/my/script.php on line 1432 Doesn't that mean that sybase_query didn't return ok? Besides, according to the documentation, the function sybase_affected_rows is only implemented for the ct library, not dblib. Unfortunately, we haven't been able to get sybase-ct to work for us, even though we tried all the hints we could get. [2001-12-11 13:58:59] [EMAIL PROTECTED] Actually, this is not a bug. The query still executes ok, but the result is different then you want. You can check with the sybase_affected_rows function if it is deleted or not: www.php.net/sybase_affected_rows Derick [2001-12-11 07:36:16] [EMAIL PROTECTED] Hello? Anybody home? I kinda need this problem to be solved, please. 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/?id=14354 Edit this bug report at http://bugs.php.net/?id=14354edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #14354 Updated: sybase_query returns 1 regardless of delete success
ID: 14354 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 8 PHP Version: 4.0.6 New Comment: Let me try to give you some more information to reproduce the problem. 1. create two tables in Sybase where one of them should include a field that represents a reference to the ID field of the other. 2. create a delete trigger on the parent table of that reference, so that deletion is prevented if a reference to the deleted record exists in the other table. 3. insert data into the tables making sure a record references another in the second table 4. use sybase_query to delete a record in the parent table. PHP will display a warning message of the type Warning: Sybase message: Children still exist in table1. Cannot delete parent table2. (severity 16) in /path/to/file.php on line x. sybase_query will return 1. 5. use sybase_query to delete a record that has no reference to the parent table. It will be deleted and sybase_query also returns 1. Previous Comments: [2002-01-08 17:02:43] [EMAIL PROTECTED] I just tried it on php 4.1.1 and the problem still exists. [2002-01-07 02:34:06] [EMAIL PROTECTED] Does this problem still exist on 4.1.1? [2001-12-12 06:41:44] [EMAIL PROTECTED] oh, ok, then it is not bogus. [2001-12-12 06:24:21] [EMAIL PROTECTED] I'm not sure if I can agree with you on that. If I don't use the @ sign, sybase_query displays a warning of the type Warning: Sybase message: Children still exist in 'table1'. Cannot delete parent 'table2'. (severity 16) in /path/to/my/script.php on line 1432 Doesn't that mean that sybase_query didn't return ok? Besides, according to the documentation, the function sybase_affected_rows is only implemented for the ct library, not dblib. Unfortunately, we haven't been able to get sybase-ct to work for us, even though we tried all the hints we could get. [2001-12-11 13:58:59] [EMAIL PROTECTED] Actually, this is not a bug. The query still executes ok, but the result is different then you want. You can check with the sybase_affected_rows function if it is deleted or not: www.php.net/sybase_affected_rows Derick 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/?id=14354 Edit this bug report at http://bugs.php.net/?id=14354edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #14354 Updated: sybase_query returns 1 regardless of delete success
ID: 14354 Updated by: lobbin Reported By: [EMAIL PROTECTED] Old Status: Open Status: Feedback Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 8 PHP Version: 4.0.6 New Comment: Does this problem still exist on 4.1.1? Previous Comments: [2001-12-12 06:41:44] [EMAIL PROTECTED] oh, ok, then it is not bogus. [2001-12-12 06:24:21] [EMAIL PROTECTED] I'm not sure if I can agree with you on that. If I don't use the @ sign, sybase_query displays a warning of the type Warning: Sybase message: Children still exist in 'table1'. Cannot delete parent 'table2'. (severity 16) in /path/to/my/script.php on line 1432 Doesn't that mean that sybase_query didn't return ok? Besides, according to the documentation, the function sybase_affected_rows is only implemented for the ct library, not dblib. Unfortunately, we haven't been able to get sybase-ct to work for us, even though we tried all the hints we could get. [2001-12-11 13:58:59] [EMAIL PROTECTED] Actually, this is not a bug. The query still executes ok, but the result is different then you want. You can check with the sybase_affected_rows function if it is deleted or not: www.php.net/sybase_affected_rows Derick [2001-12-11 07:36:16] [EMAIL PROTECTED] Hello? Anybody home? I kinda need this problem to be solved, please. [2001-12-05 18:53:13] [EMAIL PROTECTED] When trying to delete a record that Sybase will not allow to be deleted because of referential integrity constraints, sybase_query returns 1. When the record can be deleted successfully, the return code is also 1. Example: // Delete record with referential integrity constraint $strSQL = delete from MyTable where MyId=3; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1 // Delete record without referential integrity constraint $strSQL = delete from MyTable where MyId=4; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1, too We use Sybase ASE 11.9.2 on a Linux Mandrake 8 Box. We have tried several times to run sybase-ct instead of the dblib, but could never make it work. Our current configure line: ./configure \ --with-apxs=/usr/sbin/apxs \ --with-pear \ --with-gd=yes \ --with-tiff-dir=/usr/local \ --with-png-dir=/usr/local \ --with-jpeg-dir=/usr/local \ --with-ttf=/usr/src/freetype-1.3.1 \ --with-zlib \ --with-xml \ --with-ftp \ --with-mcal=../libmcal \ --with-imap=/usr/local \ --with-sybase=/opt/sybase-11.9.2 \ --with-mysql=/usr \ --with-mcrypt=/usr/local \ --with-mhash \ --with-pdflib \ --with-zlib-dir=/usr/local \ --with-fdftk=../fdftk \ --with-config-file-path=/etc/httpd/conf \ --enable-versioning \ --enable-track-vars We use both PHP3 and PHP4 as apache modules; it's a test server, we need it that way. Please contact me asap if you need more information. Michael. Edit this bug report at http://bugs.php.net/?id=14354edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #14354 Updated: sybase_query returns 1 regardless of delete success
ID: 14354 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 8 PHP Version: 4.0.6 New Comment: I'm not sure if I can agree with you on that. If I don't use the @ sign, sybase_query displays a warning of the type Warning: Sybase message: Children still exist in 'table1'. Cannot delete parent 'table2'. (severity 16) in /path/to/my/script.php on line 1432 Doesn't that mean that sybase_query didn't return ok? Besides, according to the documentation, the function sybase_affected_rows is only implemented for the ct library, not dblib. Unfortunately, we haven't been able to get sybase-ct to work for us, even though we tried all the hints we could get. Previous Comments: [2001-12-11 13:58:59] [EMAIL PROTECTED] Actually, this is not a bug. The query still executes ok, but the result is different then you want. You can check with the sybase_affected_rows function if it is deleted or not: www.php.net/sybase_affected_rows Derick [2001-12-11 07:36:16] [EMAIL PROTECTED] Hello? Anybody home? I kinda need this problem to be solved, please. [2001-12-05 18:53:13] [EMAIL PROTECTED] When trying to delete a record that Sybase will not allow to be deleted because of referential integrity constraints, sybase_query returns 1. When the record can be deleted successfully, the return code is also 1. Example: // Delete record with referential integrity constraint $strSQL = delete from MyTable where MyId=3; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1 // Delete record without referential integrity constraint $strSQL = delete from MyTable where MyId=4; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1, too We use Sybase ASE 11.9.2 on a Linux Mandrake 8 Box. We have tried several times to run sybase-ct instead of the dblib, but could never make it work. Our current configure line: ./configure \ --with-apxs=/usr/sbin/apxs \ --with-pear \ --with-gd=yes \ --with-tiff-dir=/usr/local \ --with-png-dir=/usr/local \ --with-jpeg-dir=/usr/local \ --with-ttf=/usr/src/freetype-1.3.1 \ --with-zlib \ --with-xml \ --with-ftp \ --with-mcal=../libmcal \ --with-imap=/usr/local \ --with-sybase=/opt/sybase-11.9.2 \ --with-mysql=/usr \ --with-mcrypt=/usr/local \ --with-mhash \ --with-pdflib \ --with-zlib-dir=/usr/local \ --with-fdftk=../fdftk \ --with-config-file-path=/etc/httpd/conf \ --enable-versioning \ --enable-track-vars We use both PHP3 and PHP4 as apache modules; it's a test server, we need it that way. Please contact me asap if you need more information. Michael. Edit this bug report at http://bugs.php.net/?id=14354edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #14354 Updated: sybase_query returns 1 regardless of delete success
ID: 14354 Updated by: derick Reported By: [EMAIL PROTECTED] Old Status: Bogus Status: Open Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 8 PHP Version: 4.0.6 New Comment: oh, ok, then it is not bogus. Previous Comments: [2001-12-12 06:24:21] [EMAIL PROTECTED] I'm not sure if I can agree with you on that. If I don't use the @ sign, sybase_query displays a warning of the type Warning: Sybase message: Children still exist in 'table1'. Cannot delete parent 'table2'. (severity 16) in /path/to/my/script.php on line 1432 Doesn't that mean that sybase_query didn't return ok? Besides, according to the documentation, the function sybase_affected_rows is only implemented for the ct library, not dblib. Unfortunately, we haven't been able to get sybase-ct to work for us, even though we tried all the hints we could get. [2001-12-11 13:58:59] [EMAIL PROTECTED] Actually, this is not a bug. The query still executes ok, but the result is different then you want. You can check with the sybase_affected_rows function if it is deleted or not: www.php.net/sybase_affected_rows Derick [2001-12-11 07:36:16] [EMAIL PROTECTED] Hello? Anybody home? I kinda need this problem to be solved, please. [2001-12-05 18:53:13] [EMAIL PROTECTED] When trying to delete a record that Sybase will not allow to be deleted because of referential integrity constraints, sybase_query returns 1. When the record can be deleted successfully, the return code is also 1. Example: // Delete record with referential integrity constraint $strSQL = delete from MyTable where MyId=3; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1 // Delete record without referential integrity constraint $strSQL = delete from MyTable where MyId=4; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1, too We use Sybase ASE 11.9.2 on a Linux Mandrake 8 Box. We have tried several times to run sybase-ct instead of the dblib, but could never make it work. Our current configure line: ./configure \ --with-apxs=/usr/sbin/apxs \ --with-pear \ --with-gd=yes \ --with-tiff-dir=/usr/local \ --with-png-dir=/usr/local \ --with-jpeg-dir=/usr/local \ --with-ttf=/usr/src/freetype-1.3.1 \ --with-zlib \ --with-xml \ --with-ftp \ --with-mcal=../libmcal \ --with-imap=/usr/local \ --with-sybase=/opt/sybase-11.9.2 \ --with-mysql=/usr \ --with-mcrypt=/usr/local \ --with-mhash \ --with-pdflib \ --with-zlib-dir=/usr/local \ --with-fdftk=../fdftk \ --with-config-file-path=/etc/httpd/conf \ --enable-versioning \ --enable-track-vars We use both PHP3 and PHP4 as apache modules; it's a test server, we need it that way. Please contact me asap if you need more information. Michael. Edit this bug report at http://bugs.php.net/?id=14354edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #14354 Updated: sybase_query returns 1 regardless of delete success
ID: 14354 Updated by: derick Reported By: [EMAIL PROTECTED] Old Status: Open Status: Bogus Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 8 PHP Version: 4.0.6 New Comment: Actually, this is not a bug. The query still executes ok, but the result is different then you want. You can check with the sybase_affected_rows function if it is deleted or not: www.php.net/sybase_affected_rows Derick Previous Comments: [2001-12-11 07:36:16] [EMAIL PROTECTED] Hello? Anybody home? I kinda need this problem to be solved, please. [2001-12-05 18:53:13] [EMAIL PROTECTED] When trying to delete a record that Sybase will not allow to be deleted because of referential integrity constraints, sybase_query returns 1. When the record can be deleted successfully, the return code is also 1. Example: // Delete record with referential integrity constraint $strSQL = delete from MyTable where MyId=3; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1 // Delete record without referential integrity constraint $strSQL = delete from MyTable where MyId=4; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1, too We use Sybase ASE 11.9.2 on a Linux Mandrake 8 Box. We have tried several times to run sybase-ct instead of the dblib, but could never make it work. Our current configure line: ./configure \ --with-apxs=/usr/sbin/apxs \ --with-pear \ --with-gd=yes \ --with-tiff-dir=/usr/local \ --with-png-dir=/usr/local \ --with-jpeg-dir=/usr/local \ --with-ttf=/usr/src/freetype-1.3.1 \ --with-zlib \ --with-xml \ --with-ftp \ --with-mcal=../libmcal \ --with-imap=/usr/local \ --with-sybase=/opt/sybase-11.9.2 \ --with-mysql=/usr \ --with-mcrypt=/usr/local \ --with-mhash \ --with-pdflib \ --with-zlib-dir=/usr/local \ --with-fdftk=../fdftk \ --with-config-file-path=/etc/httpd/conf \ --enable-versioning \ --enable-track-vars We use both PHP3 and PHP4 as apache modules; it's a test server, we need it that way. Please contact me asap if you need more information. Michael. Edit this bug report at http://bugs.php.net/?id=14354edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #14354 Updated: sybase_query returns 1 regardless of delete success
ID: 14354 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 8 PHP Version: 4.0.6 New Comment: Hello? Anybody home? I kinda need this problem to be solved, please. Previous Comments: [2001-12-05 18:53:13] [EMAIL PROTECTED] When trying to delete a record that Sybase will not allow to be deleted because of referential integrity constraints, sybase_query returns 1. When the record can be deleted successfully, the return code is also 1. Example: // Delete record with referential integrity constraint $strSQL = delete from MyTable where MyId=3; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1 // Delete record without referential integrity constraint $strSQL = delete from MyTable where MyId=4; $iResult = sybase_query($strSQL, $iLink ); echo Query Result: $iResult; // Displays 1, too We use Sybase ASE 11.9.2 on a Linux Mandrake 8 Box. We have tried several times to run sybase-ct instead of the dblib, but could never make it work. Our current configure line: ./configure \ --with-apxs=/usr/sbin/apxs \ --with-pear \ --with-gd=yes \ --with-tiff-dir=/usr/local \ --with-png-dir=/usr/local \ --with-jpeg-dir=/usr/local \ --with-ttf=/usr/src/freetype-1.3.1 \ --with-zlib \ --with-xml \ --with-ftp \ --with-mcal=../libmcal \ --with-imap=/usr/local \ --with-sybase=/opt/sybase-11.9.2 \ --with-mysql=/usr \ --with-mcrypt=/usr/local \ --with-mhash \ --with-pdflib \ --with-zlib-dir=/usr/local \ --with-fdftk=../fdftk \ --with-config-file-path=/etc/httpd/conf \ --enable-versioning \ --enable-track-vars We use both PHP3 and PHP4 as apache modules; it's a test server, we need it that way. Please contact me asap if you need more information. Michael. Edit this bug report at http://bugs.php.net/?id=14354edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
