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: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.