Forum .LRN Q&A: syntax error in packages/search/tcl/search-procs.xql

Collapse
1: syntax error in packages/search/tcl/search-procs.xql
Posted by Mohan Pakkurti on 07/03/02 05:30 PM
Should the following query in packages/search/tcl/search-procs.xql cvs version 1.2, have a ',' in the order by. Atleast in Oracle it did not execute. 
name="search_indexer.search_observer_queue_entry"
            select object_id, event_date, event
            from search_observer_queue
            order by event_date asc
should be ... 
name="search_indexer.search_observer_queue_entry"
            select object_id, event_date, event
            from search_observer_queue
            order by event_date, asc
Cheers.
Collapse
2: Response to syntax error in packages/search/tcl/search-procs.xql (response to 1)
Posted by Yonatan Feldman on 07/03/02 05:39 PM
the original syntax is correct. it is telling the rdbms to sort byt that column in ascending order. what error are you getting?
Collapse
3: Response to syntax error in packages/search/tcl/search-procs.xql (response to 1)
Posted by Mohan Pakkurti on 07/03/02 05:51 PM
Yikes! time for to me to take a break now...