oci8 "modifyLimitQuery" strangeness
| From: | Wolfram Kriesing | Date: | Thu, 04 Apr 2002 12:07:45 +0000 |
| Subject: | oci8 "modifyLimitQuery" strangeness | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-5187@lists.php.net to get a copy of this message | ||
if i want to add a limit using "modifyLimitQuery" on a query which has
joined (2 or in my case 3) tables Oracle returns:
Warning: OCIStmtExecute: ORA-00918: Spalte nicht eindeutig definiert
in c:\inetpub\ignaz\includes\DB\oci8.php on line 532
can someone please help me on that?
the query i send to "modifyLimitQuery" is this:
SELECT c.*,d.*,t.NAME as type
FROM EVENT_DATE d,EVENT c,EVENT_TYPE t
WHERE d.TIMESTAMP>1017917901
AND d.EVENT_ID=c.ID
AND t.ID=c.EVENTTYPE_ID
ORDER BY d.TIMESTAMP
--
Wolfram
... translating template engine ....
http://sf.net/projects/simpletpl
... authentication system ....
http://sf.net/projects/auth