Thanks Raymond. I've ended up having to write my on SQL. It seems a bit
strange that a tag supposedly to be used for searching cannot handle lists
of things to search for.
Yup on the structure thing. Sorry for any confusion...
Cheers,
Jon
-----Original Message-----
From: Raymond K. Camden [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 13:17
To: [EMAIL PROTECTED]
Subject: RE: [Searching & Indexing] CFA_CONTENTOBJECTFIND with a list of
possible searchtexts
Well, first off, you do know that search_props must be a structure, right? I
assume you mean you have something like:
search_props.PropertyName = "1,2,3"
If that is the case, then the answer is yes, you need to use multiple
searches to get the resultset. Your best bet may be to write your own SQL.
=======================================================================
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Jonathan Lim [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 09, 2000 5:52 AM
> To: [EMAIL PROTECTED]
> Subject: [Searching & Indexing] CFA_CONTENTOBJECTFIND with a list of
> possible searchtexts
>
>
> 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.
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
