Re: insane error?

Jonathan Lewis wrote:

> Order by in views is not legal in 8.0.5,
> so the error arises because a closing
> bracket is expected after
> > AND category.sect = section.id
>

Ah, I see. How else should it be done then? It seems to me that I'm only trying to do what many other people must need to do also. Surely there is a way this can be done satisfactorily?

• Kev

>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> kev wrote in message <37DE1595.361C4E1A_at_fast.no>...
> >Hi,
> >
> >I'm trying to subquery a select statement to allow me to get the Nth 10
> >rows of a result set (I'm using Oracle 8.0.5 on Linux RH6 using PHP3).
> >My original query looks like this (i've removed some of it, but I can
> >assure you this is a valid query that returns the resultset I want):
> >
> >SELECT headline.headline, headline.url, headline.grabtime
> > FROM headline, category, headline_category_link, section
> > WHERE headline_category_link.headline = headline.id
> > AND headline_category_link.category = category.id
> > :
> > :
> > AND category.sect = section.id
> > ORDER BY grabtime DESC
> >
> >and my new version of it, to just retrieve the first 10 rows, looks like
> >this:
> >
> >SELECT * FROM (
> > SELECT headline.headline, headline.url, headline.grabtime
> > FROM headline, category, headline_category_link, section
> > WHERE headline_category_link.headline = headline.id
> > AND headline_category_link.category = category.id
> > :
> > :
> > AND category.sect = section.id
> > ORDER BY grabtime DESC )
> > WHERE rownum between 1 and 10
> >
> >Now, this looks OK to me, but I get this error message when trying to
> >execute it:
> >
> >ORA-00907: missing right parenthesis
> >
> >and I am absolutely stumped. What's wrong with the query. Is there a
> >paranthesis missing? I can't see where.
> >Or is there a better way to do this?
> >
> >
> >thanks,
> >
> >- Kev
> >
Received on Tue Sep 14 1999 - 04:56:49 CDT