Re: oci8 "modifyLimitQuery" strangeness
| From: | Wolfram Kriesing | Date: | Fri, 05 Apr 2002 09:17:55 +0000 |
| Subject: | Re: oci8 "modifyLimitQuery" strangeness | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-5195@lists.php.net to get a copy of this message | ||
On Thursday 04 April 2002 19:17, you wrote:
> 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
is it possible that this makes the problem with oracle:
c.*,d.*
the asterisks, are those "illegal" with oracle
is there some oracle specialist out there ?
--
Wolfram
... translating template engine ....
http://sf.net/projects/simpletpl
... authentication system ....
http://sf.net/projects/auth