[Searching & Indexing] CFA_CONTENTOBJECTFIND with a list of possible searchtexts

[Jonathan Lim]

Hi,

Trying to do a CFA_CONTENTOBJECTFIND with a list of possible values for one
property. The property has been marked searchable.

<CFA_CONTENTOBJECTFIND
        datasource="#datasource#"
        TYPEID="#ObjectTypeDefID#"
        stProperties="#search_props#"
        lPropertiesPrecedence="#search_props_precendence#"
        R_STOBJECTS="st_objects"
>

So I have multiple values in search_props for a given property. Eg.
search_props="12,13,14"

However, looking at the SQL produced, it suggests this cannot be done except
in a loop or by hacking the tag. Have I missed something obvious?

SQL Produced:
select objectid
        from properties p
        where 
                objectid in (:1,:2,:3,:4,:5,:6,:7)
                and
        ( p.propertyname = :8
                and p.chardata = 
         :9
        )

Cheers,
Jon

--
Jonathan Lim    [EMAIL PROTECTED]
Netdecisions    http://www.netdecisions.co.uk/
------------------------------------------------------------------------------
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.