please be patient and help me with this cfsearch/cfindex questions.
This is my page to run cfindex:
<--------------------------------CreateCollection.cfm------------------------->
<CFQUERY NAME="GetContentDB" datasource="#dsn#" cachedwithin="#CreateTimeSpan(12,0,0,0)#">
SELECT
N.intNoticiasID ID,
CONCAT('http://127.0.0.1:8500/miynet/content', N.intNoticiasID, '.html') caminho,
N.strNoticiasTit Titulo,
N.strNoticiasGravata Frase,
N.memoNoticiasConteudo Conteudo,
N.dtNoticiasDataInc DataCriacao,
S.strSiteName SiteName
FROM
tblsite S
INNER JOIN tblnoticias N ON (S.strSiteID = N.strSiteID)
WHERE S.strSiteID='#siteID#'
AND N.intNoticiasStatus=1
UNION
SELECT
C.intConteudoNr ID,
CONCAT('http://127.0.0.1:8500/miynet/page', C.intConteudoNr, '.html') caminho,
C.strTitulo Titulo,
C.strFrase Frase,
C.memoConteudo Conteudo,
C.dtCriacao DataCriacao,
S.strSiteName SiteName
FROM
tblconteudo C
INNER JOIN tblsite S ON (C.strSiteID = S.strSiteID)
WHERE S.strSiteID='#siteID#'
ORDER BY DataCriacao DESC
</CFQUERY>
<cfindex
action=""
collection="teste"
key="ID"
type="CUSTOM"
title="Titulo"
query="GetContentDB"
body="caminho,Frase,Conteudo,DataCriacao"
language="Spanish">
Works fine and return 12 records.
<--------------------------------Search.cfm------------------------->
<!---here perform database verity search--->
<cfsearch
collection="teste"
name="GetContentDB"
type="SIMPLE"
criteria="<STEM> #UserCriteria#"
language="Spanish">
Here begin my problem... Returns only if UserCriteria is EQUAL(exactly) any word in collection. Don't works with partial word.
I'm looking for a results like this:
#Titulo#
#Frase# #DataCriacao#
#Conteudo#
but Verity don't perform this options. Only #SUMMARY# which is very very ugly... How to do that?
p.s.: what's the best practices for Verity searches?
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
