Hi Eron,
Since my computer doesn't like <matches> tag, I combined verity search with
SQL query and solved the problem. Now it works perfect.
Thank you very much for your help.
Sima
----- Original Message -----
From: Eron Cohen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 28, 2000 12:38 PM
Subject: Re: verity search problem
> Hi Sima,
>
> Great news that you have CFSEARCH almost working.
>
> Since you can make the search work by manually putting in some basic
search
> words, you know that your trouble must be in the way you are concatonating
> your search string. You gave an example search string that is not
working:
> "(cf_custom2 'Picture','Video')And (mother)" I am not sure why you have
> "CF_CUSTOM2" in your search. The rest of it looks like it would work.
Just
> to test, try manually fixing the search criteria to be ('Picture','Video')
> And (mother).
>
> Eron
>
> ----- Original Message -----
> From: Sima Lee <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, May 28, 2000 1:02 PM
> Subject: Re: verity search problem
>
>
> > Hi Eron ,
> > Thank you for your hint. When I manually enter a word as the criteria in
> the
> > search tag it works. So I deleted the whole search form and start a very
> > simple form to make sure the Form.Criteria is submitted properly. And it
> > works perfect.
> >
> > Now, the problem is my search should allow the user to select different
> type
> > to narrow the results. So when I add some more selections to the form
> >
> > The old problem comes back again. Now I send you all the code for your
> > advice.
> >
> > Here is the code in the search file:
> >
> > <cfif Isdefined("Form.all")>
> > <!--- "All" is a checkbox field. If "All" is selected then ingnore any
> > type just matches the form.Criteria --->
> > <cfset TheCriteria="#Form.Criteria#">
> >
> > <!--- If "All is not selected --->
> > <cfelse>
> > <cfif Isdefined("Form.ItemType")>
> >
> > <!--- " ItemType" is a checkbox field which allows multiple
selections.
> > If "ItemType" is defined then set TheCriteria eq the ItemType in the
> field
> > matches the Form.Criteria --->
> >
> > <cfset TheCriteria="(cf_custom2 <matches>
> > #Form.ItemType#)And (#Form.Criteria#)">
> > <cfelse>
> > <!--- if ItemType is not defined then just mathes the
Form.Criteria --->
> > <cfset TheCriteria="#Form.Criteria#">
> > </cfif>
> > </cfif>
> >
> > <cfoutput>#TheCriteria#</cfoutput>
> > <CFSEARCH COLLECTION="test"
> > name="GetResults"
> > CRITERIA="#TheCriteria#">
> >
> > If I select All or don't make any selection it just take the
> Form.Criteria
> > and gives me the correct result. But If I make any selection in the
> ItemType
> > it always gives me "0" results. If I select Picture and Vedio in the
> > Form.ItemType field and enter mother in the Form.Criteria field , then
try
> > to print out it like:<cfoutput>#TheCriteria#</cfoutput> the result is
> > :(cf_custom2 'Picture','Video')And (mother) . Is it should look like
this?
> > If it is coreect why it doesn't work in the <cfsearch> tag?
> >
> >
> > The code in the indexfile is like this:
> >
> > <cfquery name="GetItems" datasource="test">
> > SELECT ItemID, ItemName, Short_Desc,Long_Desc,
> Author,Year,TopCategoryName,
> > SubCategoryName,SubSubCategoryName,FileName
> > FROM items
> >
> > </cfquery>
> >
> > <cfindex action="update"
> > collection="gleemail"
> > key="ItemID"
> > type="custom"
> > title="ItemName"
> > query="GetItems"
> > body="Short_Desc,Long_Desc,
> > Author,Year,TopCategoryName,SubCategoryName,SubSubCategoryName,FileName"
> > custom1="FileName"
> > custom2="ItemType">
> >
> >
> >
> > Here is the code in the searchform file :
> >
> > <table align="center">
> > <cfform action="dsp_search.cfm" method="post"><p>
> > <tr>
> > <td colspan="2">
> > Please enter a keyword you want to search<br>
> > </td>
> > </tr>
> > <tr><td colspan="2">   </td></tr>
> > <tr>
> > <td colspan="2">
> > All <cfinput type="checkbox" name= "All" Value="All">
> > Picture <cfinput type="checkbox" name = "ItemType" value="'Picture'"
> > checked>
> > Animation <cfinput type="checkbox" name = "ItemType"
> > value="'Animation'">
> > Video <cfinput type="checkbox" name = "ItemType" value="'Video'">
> > Audio <cfinput type="checkbox" name = "ItemType" Value="'Audio'">
> >
> > </td>
> > </tr>
> > <tr><td colspan="2">   </td></tr>
> >
> > <tr>
> > <td colspan="2">
> > Please enter a keyword you want to search<br>
> > </td>
> > </tr>
> >
> > <tr>
> > <td colspan="2">
> > <cfinput type="text" name="Criteria" size="30" maxlength="100"
> > required="yes" message="You must enter a keyword">
> > <input type="submit" value="Go!">
> > </td>
> > </tr>
> > </cfform>
> >
> > </table>
> >
> > Thank you again for your help.
> >
> >
> > ----- Original Message -----
> > From: Eron Cohen <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, May 26, 2000 3:59 PM
> > Subject: RE: verity search problem
> >
> >
> > > Sima,
> > >
> > > What happens when you manually type in a search word that you know
must
> > > exist in your collection?
> > >
> > > Can you post the rest of the code you're using?
> > >
> > > Eron
> > >
> > > PS- There have been alot of helpful posts regarding verity recently.
I
> > > don't have any of others handy, but here's some information I posted a
> few
> > > weeks ago that may help you:
> > >
> > >
> > > 1) The verity search engine built into CF is somewhat stripped down
> from
> > > the full version. Although, as I have learned from posts on this
forum,
> > the
> > > version that comes with Cold Fusion is full of "undocumented features"
> > that
> > > coincidently turn out to be features in the full version :-O
> > >
> > > 2) To say the least, Verity can be weird.
> > >
> > > I've definitely had my share of problems with Verity. Probably the
> worst
> > > one of all is that it doesn't tell you when there's an error...it just
> > > doesn't work. Here are a couple of other points from my presentation
> that
> > > may help (If you do go looking for the entire presentation, its under
> PAST
> > > MEETINGS > February > Eron Cohen):
> > >
> > >
> > > --Verity searches can be CaSe sensitive. I typically force keyword
> > searches
> > > into lower case.
> > >
> > > --When using CFINDEX you must be sure that all the fields you include
in
> > the
> > > BODY= parameters are valid fields from your query. Often you won't
get
> an
> > > error message and your index won't work!
> > >
> > > And possibly the biggest GOTCHA:
> > >
> > > --**********ALWAYS make sure your KEY= field is unique for EVERY
record.
> > If
> > > you don't do this, as soon as verity encounters a duplicate key it
will
> > stop
> > > indexing there (and it won't give you any error
> messages!)***************
> > >
> > >
> > > 3) I have done quite a bit of indexing of large amounts of data. I am
> not
> > > exactly sure what the limit is, but in fact, there IS a limit to the
> size
> > of
> > > your collections! This is documented in Allaire's KB (article
#11934).
> > >
> > > This is something you can get around because in CFSEARCH you can name
> more
> > > than 1 collection to search at the same time, so you can always break
> down
> > > what you want to search into separate collections.
> > >
> > > I recently gave a presentation about Verity searches at the Maryland
> Cold
> > > Fusion user's group. You can download my PowerPoint slides there:
> > >
> > > http://www.cfug-md.org/meetings.cfm (February 8th 2000)
> > >
> > > -----Original Message-----
> > > From: Sima Lee [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, May 26, 2000 4:48 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: verity search problem
> > >
> > >
> > > Thank you for such a quick response. But I tried everything like the
> > > following and it doesn't work:
> > >
> > > CFSEARCH COLLECTION="test"
> > > NAME="GetItems"
> > > CRITERIA="#Form.criteria#">
> > >
> > > or
> > > <CFSEARCH COLLECTION="test"
> > > NAME="GetItems"
> > > CRITERIA=Form.criteria>
> > > or
> > >
> > > <CFSEARCH COLLECTION="test"
> > > NAME="GetItems"
> > > CRITERIA="Form.criteria">
> > > They all return "0" record.
> > >
> > > Sima
> > >
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: Eron Cohen <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Friday, May 26, 2000 3:30 PM
> > > Subject: RE: verity search problem
> > >
> > >
> > > > One thing that could be wrong: I believe you actually NEED # signs
for
> > > your
> > > > Criteria= statement...
> > > > What happens if you use:
> > > >
> > > > <CFSEARCH COLLECTION="test"
> > > > NAME="GetItems"
> > > > CRITERIA="#Form.criteria#">
> > > >
> > > > HTH,
> > > >
> > > > Eron
> > > >
> > > > -----Original Message-----
> > > > From: Sima Lee [mailto:[EMAIL PROTECTED]]
> > > > Sent: Friday, May 26, 2000 4:10 PM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: verity search problem
> > > >
> > > >
> > > > This is a multi-part message in MIME format.
> > > >
> > > > ------=_NextPart_000_0041_01BFC724.71016490
> > > > Content-Type: text/plain;
> > > > charset="iso-8859-1"
> > > > Content-Transfer-Encoding: quoted-printable
> > > >
> > > > Hi All,
> > > >
> > > > I am new to ColdFusion and try to use verity search . This is the =
> > > > problem I got:
> > > > I created a collection and indexed it . It says there is 8 records
in
> it
> > =
> > > > , which is true. But when I use the cfsearch tag to search , it
always
> =
> > > > gives me zero records no matter what I type in as a criteria. But if
I
> =
> > > > change Criteria=3D"" in the search tag it gives me all the 8
> records.
> > =
> > > > For example:
> > > >
> > > > <CFSEARCH COLLECTION=3D"test"=20
> > > > NAME=3D"GetItems"=20
> > > > CRITERIA=3D"Form.criteria">
> > > > Will return 0 record.
> > > >
> > > > but
> > > > <CFSEARCH COLLECTION=3D"test"=20
> > > > NAME=3D"GetItems"=20
> > > > CRITERIA=3D"">
> > > >
> > > > will return all the 8 records.
> > > >
> > > > Could anybody tell me why the criteria does not work? Thanks in
> advance.
> > > >
> > > >
> > > > ------=_NextPart_000_0041_01BFC724.71016490
> > > > Content-Type: text/html;
> > > > charset="iso-8859-1"
> > > > Content-Transfer-Encoding: quoted-printable
> > > >
> > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > > > <HTML><HEAD>
> > > > <META content=3D"text/html; charset=3Diso-8859-1" =
> > > > http-equiv=3DContent-Type>
> > > > <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
> > > > <STYLE></STYLE>
> > > > </HEAD>
> > > > <BODY bgColor=3D#ffffff>
> > > > <DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
> > > > <DIV> </DIV>
> > > > <DIV><FONT face=3DArial size=3D2>I am new to ColdFusion and try to
use
> =
> > > > verity search=20
> > > > . This is the problem I got:</FONT></DIV>
> > > > <DIV><FONT face=3DArial size=3D2>I created a collection and indexed
it
> .
> > =
> > > > It says=20
> > > > there is 8 records in it , which is true. But when I use the =
> > > > cfsearch tag=20
> > > > to search , it always gives me zero records no matter what I type in
> as
> > =
> > > > a=20
> > > > criteria. But if I change Criteria=3D"" in the search
tag
> it
> > =
> > > > gives me=20
> > > > all the 8 records. For example:</FONT></DIV>
> > > > <DIV> </DIV>
> > > > <DIV><FONT face=3DArial size=3D2><CFSEARCH=20
> > > >
> >
COLLECTION=3D"test" <BR> &n=
> > > > bsp; =20
> > > > NAME=3D"GetItems" =
> > > > <BR> =20
> > > > CRITERIA=3D"Form.criteria"></FONT></DIV>
> > > > <DIV><FONT face=3DArial size=3D2>Will return 0 record.</FONT></DIV>
> > > > <DIV> </DIV>
> > > > <DIV><FONT face=3DArial size=3D2>but
> > > > <DIV><FONT face=3DArial size=3D2><CFSEARCH=20
> > > >
> >
COLLECTION=3D"test" <BR> &n=
> > > > bsp; =20
> > > > NAME=3D"GetItems" =
> > > > <BR> =20
> > > > CRITERIA=3D""></FONT></DIV>
> > > > <DIV> </DIV>
> > > > <DIV>will return all the 8 records.</DIV>
> > > > <DIV> </DIV>
> > > > <DIV>Could anybody tell me why the criteria does not work? Thanks
> in=20
> > > > advance.</DIV></FONT></DIV>
> > > > <DIV> </DIV></BODY></HTML>
> > > >
> > > > ------=_NextPart_000_0041_01BFC724.71016490--
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > --
> > > > --
> > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > To Unsubscribe visit
> > > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > or
> > > > send a message to [EMAIL PROTECTED] with
'unsubscribe'
> > in
> > > > the body.
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > ----
> > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > To Unsubscribe visit
> > >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > > the body.
> > >
> >
>
> --------------------------------------------------------------------------
> > --
> > > --
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > > the body.
> > >
> >
>
> --------------------------------------------------------------------------
> > ----
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> > >
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
