Results 1 to 2 of 2

Thread: Full text query

  1. #1
    Acrhbishop Makarios Guest

    Full text query

    I have a problem with sql 7 full text query. Everything appears to be in place the database is enabled and the catalogue populated but a query like this
    select * from risks_intercat WHERE CONTAINS(RISK_NOTES, ' "bean curd" &#39
    always returns this;
    Search on full-text catalog 'ftc_Risks_ic' for database ID 8, table ID 329768232 with search condition ' "bean curd" ' failed with unknown result (8bcf8cc).
    has anybody got any ideas why?


  2. #2
    Nazer Guest

    Full text query (reply)



    Instead you may use
    select * from risks_intercat WHERE RISK_NOTES, Like '% "bean curd" %'

    ------------
    Acrhbishop Makarios at 8/31/01 12:19:40 PM

    I have a problem with sql 7 full text query. Everything appears to be in place the database is enabled and the catalogue populated but a query like this
    select * from risks_intercat WHERE CONTAINS(RISK_NOTES, ' "bean curd" &#39
    always returns this;
    Search on full-text catalog 'ftc_Risks_ic' for database ID 8, table ID 329768232 with search condition ' "bean curd" ' failed with unknown result (8bcf8cc).
    has anybody got any ideas why?


Posting Permissions

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