You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@struts.apache.org by "CRANFORD, CHRIS" <ch...@setechusa.com> on 2004/06/14 19:13:18 UTC

Query question

Anyone here familiar with using CATSEARCH type oracle queries?  If so, I am
trying to do something like:

SELECT COLNAME
   FROM MYTABLE
 WHERE CATSEARCH(MYFIELD,'motor',NULL) > 0 
         OR SHORT_DESCRIPTION LIKE '%motor%'

The problem is I get an oracle error about functional invocation; however I
and use an AND in my where clause and no errors occur.  Thanks for any help
anyone can provide.

_______________________________________________________
Chris Cranford
Programmer/Developer
SETECH Inc. & Companies
6302 Fairview Rd, Suite 201
Charlotte, NC  28210
Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042 
Email: chris.cranford@setechusa.com