Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.12.2

Bug #613 Patch: Solution for quoting table and column names OCI8 connection issues
Submitted: 2004-01-22 18:53 UTC
From: justinpatrin Assigned: danielc
Status: Closed Package: DB
PHP Version: 4.3.3 OS: Linux
Roadmaps: (Not assigned)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 43 + 4 = ?

 
 [2004-01-22 18:53 UTC] justinpatrin
Description: ------------ Each database has a specific way of quoting table and column names. For instance, Oracle uses " and mysql uses `. This patch adds a quoteEntity() function to common.php, mysql.php, and oci8.php to support this. The function name is, of course, subject to change by the developers of DB. Note: functionality already released in DB_DataObject supports this method in DB, even though this patch has not been put in CVS or a release yet. This patch also adds extra functionality for the OCI8 driver to support connecting without setting up a TNS. It should still be fully BC. Please see the patch at: http://www.reversefold.com/~papercrane/DB.quoteEntities.diff

Comments

 [2004-02-06 05:42 UTC] danielc
Thanks for the suggestion for delimiting identifiers. The quoteIdentifier() has been added to CVS. The connection idea should be given more consideration. I don't know if it would cause problems or not. It will have to wait for a later release. FYI: These concepts are fairly different. In the future, it'd be a good idea to make two separate feature requests.
 [2004-02-06 06:19 UTC] danielc
Please open up a new feature request for the connection matter. Thanks.