I believe there is an enhancements request @ the Spectra forums. I'd suggest
asking for it. In theory, you can say that if the value of the struct key is
a list (just say listlen(val) gte 2), then convert the SQL from:
where foo = #val#
to
where foo in (#val#)
or some such.
=======================================================================
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 9:31 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [Searching & Indexing] CFA_CONTENTOBJECTFIND with a list of
> possible searchtexts
>
>
> 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.
>
------------------------------------------------------------------------------
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.
