ID: 13931 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: Windows NT4 SP6a PHP Version: 4.1.0 New Comment:
Do please try 4.2.1, I made a big mistake in 4.2.0 that wasn't tested/caught that caused queries to not really work at all. Sorry for the run around. Previous Comments: ------------------------------------------------------------------------ [2002-04-23 11:18:29] [EMAIL PROTECTED] see above... ------------------------------------------------------------------------ [2002-04-23 11:17:28] [EMAIL PROTECTED] Have tried with PHP 4.20, now gives different problems. Please also see bug-id 16756 for that description. I have tried 4.1.0 and could reproduce the problem on that. ------------------------------------------------------------------------ [2002-04-17 03:27:41] [EMAIL PROTECTED] I will try and do this the following week with the latest version. This is because i am currently on another project outside the office. I will update then. ------------------------------------------------------------------------ [2002-04-16 14:05:52] [EMAIL PROTECTED] The version of PHP that this bug was reported in is too old. Please try to reproduce this bug in the latest version of PHP (available from http://www.php.net/downloads.php If you are still able to reproduce the bug with one of the latest versions of PHP, please change the PHP version on this bug report to the version you tested and change the status back to "Open". ------------------------------------------------------------------------ [2001-11-06 03:26:51] [EMAIL PROTECTED] Also, i have seen a similar error if i reference a field which has a relationship with a primary key in another table - something like projects.userid, which is in the users table - but don't get any fields from that related table. consider this: -------------- SELECT projects.proj_num, projects.status, clients.name, projects.user_id FROM projects INNER JOIN clients ON projects.clientID=clients.clientID WHERE projects.proj_status='Open'; The ODBC error is 'AMBIGUOUS COLUMN NAME user_id' This must defenately be a bug, because user_id is only referenced once in the query, with source table 'projects'. I must add that there is also a field 'user_id' in the 'clients' table, but i am not querying that field. Also, there is no relationship between the 'clients.user_id' and the 'projects.user_id'. They are related to the users table, so i can set the 'owner' of a client or project. ------------------------------------------------------------------------ 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/13931 -- Edit this bug report at http://bugs.php.net/?id=13931&edit=1
