Um, did anyone notice that the SQL appears to be both superfluous and
incorrect?
select distinct p.objectid
from properties p, properties r, properties s
where p.objectid = r.objectid
and p.objectid = t.objectid
and t.propertyname = 'char_fname'
and t.chardata = 'Tiger'
and s.propertyname ='char_lname'
and s.chardata = 'Woods'
....Should be something simpler like...
select distinct p.objectid
from properties p, properties r
where p.objectid = r.objectid
and p.propertyname = 'char_fname'
and p.chardata = 'Tiger'
and r.propertyname ='char_lname'
and r.chardata = 'Woods'
Also, you can easily also join on the types and objects tables to find
properties from objects of a certain type.
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 07, 2001 8:54 AM
To: Spectra-Talk
Subject: RE: <cfa_ContentObjectFind> and SQL-Style Search
Eh? As far as I know 1.5 supports this. You simply used the
propertiesCriteria="ALL" property.
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Michael Collins [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 9:06 PM
> To: Spectra-Talk
> Subject: RE: <cfa_ContentObjectFind> and SQL-Style Search
>
>
> Zhiyuan,
>
> To do what you are asking you will need to do a Self Join using SQL.
> Cfa_cof does not support an "and" condition using 2 properties.
>
> Check out http://www.allaire.com/Handlers/index.cfm?ID=16106&Method=Full
> for complete details.
>
> HTH
>
>
> -----Original Message-----
> From: Zhiyuan Ma [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 4:19 PM
> To: Spectra-Talk
> Subject: <cfa_ContentObjectFind> and SQL-Style Search
>
>
>
> To search content objects on a given content object type with two
> properties
> as searchable, one property is defined as chardata and another property is
> defined as integerdata, which way is more efficiency - use
> <cfa_ContentObjectFind> or do a SQL-Style search such as <Select objectid
> from properties where chardata is 'XYZ' and integerdata=123>?
>
> Thanks,
>
> Zhiyuan
>
> ~.~.~.~.~.~.~.~.~.~.~.~.~.~.~
> SVMedia
> 940 South Avenue West
> Suite D
> Westfield, NJ 07090
>
> ph 908.789.4200
> fax 908.789.4266
> http://www.svmedia.com/
>
> Strategic Internet Business Solutions
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
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.
