I've got the latest update applied, so why does this:
<cfset stProps=structnew()>
<cfif len(trim(cd.title))>
<cfset stProps.title="*#trim(cd.title)#*">
</cfif>
<cfif len(trim(cd.owner))>
<cfset stProps.owner="*#trim(cd.owner)#*">
</cfif>
<cfif len(trim(cd.title)) or len(trim(cd.owner))>
<cfa_contentObjectFind
propertiescriteria="ONE_OR_MORE"
stproperties="#stProps#"
bactiveOnly="false"
dataSource = "#request.cfa.objectstore.dsn#"
typeID = "#mytypeID#"
r_stObjects = "stObj">
</cfif>
Result in this:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image
data type cannot be selected as DISTINCT.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (430:3) to (430:90).
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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.
