#13809 [Bgs]: Openlink 3.2 and 4.0 odbc_do and single quotes

ID: 13809 User updated by: Grant dot Walters at walters dot co dot nz Reported By: Grant dot Walters at walters dot co dot nz Status: Bogus Bug Type: ODBC related Operating System: SCO Openserver 5.0.5 & RH Lnux 7 PHP Version: 4.3.1 New Comment: Sniper. Did you even read my basic code sample? The problem is how to build a query that contains data that contains a single quote. I agree it is/was probably an Openlink driver issue. Previous Comments: ------------------------------------------------------------------------ [2003-07-10 18:52:49] sniper@php.net After searching with google for this issue, it's pretty clear your code is broken, you should use single quotes in the WHERE statements. Anyway, this can't really be PHP bug.. ------------------------------------------------------------------------ [2003-05-03 16:57:39] Grant dot Walters at walters dot co dot nz Sorry about the delay. I have tested with the 4.1 openlink and have drawn the same basic conclusions as previously with odbc_do. A straight query can not be built when the value being looked for contains a (') character. No combination of character escaping or quote usage (" vs ') seems to alleviate the issue. ------------------------------------------------------------------------ [2003-02-04 01:00:02] php-bugs at lists dot php dot 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". ------------------------------------------------------------------------ [2003-01-19 19:00:14] kalowsky@php.net 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 Removing ahill assigned to status, and asking to try a newer version ------------------------------------------------------------------------ [2002-05-22 15:22:24] kalowsky@php.net Assigning to Andrew ------------------------------------------------------------------------ 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/13809 -- Edit this bug report at http://bugs.php.net/?id=13809&edit=1