Re: oci8 "modifyLimitQuery" strangeness
| From: | Wolfram Kriesing | Date: | Thu, 04 Apr 2002 17:17:02 +0000 |
| Subject: | Re: oci8 "modifyLimitQuery" strangeness | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-5188@lists.php.net to get a copy of this message | ||
On Thursday 04 April 2002 14:07, Wolfram Kriesing wrote:
> 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
in english this message says:
"column defined ambigiously"
>
> 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