I believe this is a known issue, with a fix forthcoming soon. ======================================================================= Raymond Camden, ColdFusion Jedi Master for Macromedia
Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Derek Westfall [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 14, 2002 1:28 PM > To: Spectra-Talk > Subject: cfa_contentobjectfind 1.5.1 distinct error > > > 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). > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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.
