php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #5140 Impossible to execute join requests
Submitted: 2000-06-20 10:28 UTC Modified: 2000-06-20 11:06 UTC
From: marshall dot maximus at caramail dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0 Release Candidate 1 OS: WinNT 4
Private report: No CVE-ID: None
 [2000-06-20 10:28 UTC] marshall dot maximus at caramail dot com
SELECT PL_DINTERV FROM SEMAINE,PLAGE_HORAIRE WHERE PL_CODE_SE=SE_CODE AND SE_CODE_UT=14

Simple join request (it works well under ASP,SQLPLUS,ACCESS)

Error message : 
Warning: SQL error: [Microsoft][ODBC driver for Oracle]Impossible d'utiliser le curseur de table de caract?res sur join, avec une clause distincte union, intersection ou moins ou sur une s?rie de r?sultats en lecture seule, SQL state S1C00 in SQLExecDirect in d:\Inetpub\wwwroot\polop\dates.php on line 20

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-06-20 11:06 UTC] kara at cvs dot php dot net
This seems to be a driver restriction. Maybe newer drivers
(from Oracle) help.
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved.
Last updated: Thu Jun 18 00:00:02 2026 UTC