php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: marshall dot maximus at caramail dot com
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Sat Jun 01 08:01:32 2024 UTC