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
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:
40 - 2 = ?
Subscribe to this entry?

 
 [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: Sun Jun 16 05:01:29 2024 UTC