DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Intermedia

  1. #1
    Join Date
    Sep 2000
    Posts
    12
    Hello, I am having problems with a intermedia text query.
    The problem is this:

    when I issue a select statement such as

    select colum1 from some_table where contains(column2,'blah',1) >0;

    I get my results just fine. As soon as I add
    the score(1) operater like

    select column1,score(1) from some_tabl where contains(column2,'blah',1) >0

    the query just hangs. I am running these
    queries from a web application so the browser
    just cranks away, never returning anything. I have used
    these queries before and never had a problem. If anyone
    has any ideas, I would greatly appreciate them

    Thanks
    Billy.

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    Have you tried running the command from sqlplus or something other than the web app? Maybe you can get more information on why it's hanging. Try using explain plan to see the steps it's taking.

    I haven't used intermedia a lot yet but do have it installed, once I get some time I'll run some test queries and see what I can find out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width