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.
