I reviewed this KB when 1.5 was released and I remember looking at the below:

propertiesCriteria (optional - default: ALL) - criteria for property matching: ALL - all properties must be matched ANY - at least one property must be matched (same as "ONE_OR_MORE") NONE - none of the properties can match

and thinking that does not describe a feature that dynamically builds self joins based on the number of critera.

Well - I did not do enough looking... and I am incorrect, and 1.5 does address this issue.

You need to look at the SQL code to see that yes it does build the necessary self joins.

Thank you Ray for catching this!!!

-----Original Message----- From: Raymond Camden [mailto:jedimaster@macromedia.com] 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 : jedimaster@macromedia.com ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda

> -----Original Message----- > From: Michael Collins [mailto:mcollins@macromedia.com] > 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:zma@svmedia.com] > 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 spectra-talk-request@houseoffusion.com with 'unsubscribe' in the body.