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.