- see footer for list info -<
When I try and use cfsearch with type="explicit" I get the following
error (it works fine with type="simple"):
An error occurred while performing an operation in the Search Engine
native library. coldfusion.tagext.lang.CFSearchTagException: Error # -2
Error E1-0106 (Query Builder): No topic built..
Searched google, a few people asking this question but no answers. Here
is my code:
<cfcollection action="create" collection="myCollection"
path="#getDirectoryFromPath(getCurrentTemplatePath())#">
<cfquery name="qMessage" datasource="#ds#" username="#dsusername#"
password="#dspassword#">
SELECT imessageid as messageID,
messages.ithreadid as threadID,
threads.icategoryid as categoryID,
txmessage as [message],
vchmessagetitle as [title],
dtmessagedate as [date]
FROM messages
INNER JOIN threads
ON messages.ithreadid = threads.ithreadid
</cfquery>
<cfindex collection="myCollection"
action="update"
type="custom"
title="title"
body="message"
key="threadid"
custom1="date"
custom2="categoryid"
query="qMessage">
<cfsearch collection="myCollection" criteria="cat" name="qSearch"
type="explicit">
Cheers, dominic
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
