ID: 13931 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Bogus +Status: Open Bug Type: ODBC related Operating System: Windows NT4 SP6a -PHP Version: 4.0.6 +PHP Version: 4.1.0 New Comment:
see above... Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2001-11-05 11:19:53] [EMAIL PROTECTED] oops...missed a ')' in my code here at the end of the 'do' loop. I have got this right in my original code ;) ------------------------------------------------------------------------ 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
