0 Replies Latest reply on Apr 1, 2008 6:47 PM by Newsgroup_User

    db query-based Verity collection with Categories?

    Level 7
      posted this on HOF list, but got no replies in a day... will try here...

      1) does a database query-based Verity collection support Categories? or
      is it supported only for document/directory based collections?

      2) i am creating a collection and search interface for a multi-faceted
      photo database, where each photo has multiple facets, categories and
      keywords assigned to it.
      while i can create a collection that combines all the
      facets/categories/keywords in the collection's body (together with title
      and description), i think it will work better with facets and categories
      stored as collection/photo categories...
      i am using custom fields to store photo properties, photographer name
      and pre-set galleries a photo is assigned to, which takes up all 4
      allowed custom fields...

      maybe someone has done something like this before and can share the
      insight?...

      here's the collection index code:

      <cfindex
      action="refresh"
      collection="photodb_simplesearch"
      type="custom"
      query="imgdata"
      key="image_id"
      title="image_file"
      body="title,description,facets,cats,keywords" custom1="orientation"
      custom2="colormodel" custom3="galleries" custom4="owner_name">

      the facets, cats, keywords and galleries are comma-delimited lists of
      each photo's facets, cats, keywords, galleries and their respective
      descriptions [created with mysql's group_concat() function - gotta love
      that thing!] for the prupose of being searchable for user-entered search
      phrase.

      any thoughts/suggestions?

      --

      Azadi Saryev
      Sabai-dee.com
      http://www.sabai-dee.com/