Using Verity to search BLOB fields in DB

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default Using Verity to search BLOB fields in DB

    Hello All!

    We have an Oracle 9i database with a table containing documents (PDF, Word,
    Excel, etc) stored in that table in a BLOB column. We want to use Verity to
    index this column so users can search on it.

    We are having problems doing this. We query the database, we attempt to put
    the results into the collection, but then when we search on it, we get no
    results.

    Any help or ideas are appreciated!

    CF_DAWG Guest

  2. Similar Questions and Discussions

    1. Blob fields and images
      I am using MYSQL and flash 8. I have been able to connect to our mysql tables and read and update text. I need to develop a flash app where...
    2. BLOB search
      Please help, I have saved files into my database in a BLOB (long binary data) type and wanted to know if I can search this field? If not what is...
    3. #25118 [Opn->Ver]: can't store data in blob fields
      ID: 25118 Updated by: kalowsky@php.net Reported By: php at jschreiber dot com -Status: Open +Status: ...
    4. #25118 [Opn->Fbk]: can't store data in blob fields
      ID: 25118 Updated by: kalowsky@php.net Reported By: php at jschreiber dot com -Status: Open +Status: ...
    5. #25118 [Fbk]: can't store data in blob fields
      ID: 25118 Updated by: sniper@php.net Reported By: php at jschreiber dot com Status: Feedback Bug Type: ...
  3. #2

    Default Re: Using Verity to search BLOB fields in DB

    I called Macromedia support on this one. They said that Verity as it currently
    is with CFMX 7, does not support full text indexing of BLOBs in a table. We
    chose to go with Oracle Text Search instead, but could also have gone the
    Google route, as their search utility indexes BLOBs also.

    CF_DAWG Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139