Using CATEGORY with CFSEARCH returns no values. Using it without works... : cfsearch, category

May 13, 2008 08:36am pdt

1. Zvonko 77,600
2. _agx_ 71,157
3. SidFishes 62,645
4. Plucka 48,800
5. SBennett 46,600
6. gdemaria 42,695
7. hielo 31,250
8. Mr_Nil 24,500
9. srikanth... 19,310
10. pmascari 18,250
10. zadoc 18,250
12. Kerrdo 15,300
13. meverest 13,575
14. dgrafx 13,250
15. erikTsomik 12,550

1. mrichmon 1,346,158
2. trailbla... 688,918
3. pinaldave 661,396
4. anandkp 591,655
5. dgrafx 525,188
6. gdemaria 484,616
7. SidFishes 438,595
8. _agx_ 419,622
9. Tacobell777 390,907
10. Plucka 390,168
11. Jester_48 378,245
12. danrosen... 348,915
13. mkishline 295,040
14. mmc98dl1 271,238
15. entrance... 248,605

09.21.2007 at 12:07PM PDT, ID: 22845037

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.9

Using CATEGORY with CFSEARCH returns no values. Using it without works...

Zone: ColdFusion Application Server

Tags: cfsearch, category

I am a little perplexed by this and I must be doing something wrong. I am running CFMX7 on RE4 if that helps.

I have created several verity collections and enabled category support for them. I have indexed my content and by doing a dump can see I have 46 records and that my categories are set properly.

When I do a cfsearch and include category=xxx I get zero results.

When I do a cfsearch and DO NOT include the category tag I get results.

Even at the most simplistic programming level it doesnt work. Here is a basic idea of what I am trying to do:

=====returns no results======
<cfsearch collection="meetings_data" name="get_info" criteria="hotel" category="boston">

<cfoutput>
#get_info.summary#<br>
</cfoutput>

<cfdump var="#get_info #">

=====returns 1 results======
<cfsearch collection="meetings_data" name="get_info" criteria="hotel">

<cfoutput>
#get_info.summary#<br>
</cfoutput>

<cfdump var="#get_info #">

The dump does show that the CATEGORY for the record is boston. I dont get it. I must be missing something simple.

Start your free trial to view this solution

Question Stats

Zone: Software

Question Asked By: krugar77

Solution Provided By: jeninbrighton

Participating Experts: 2

Solution Grade: B

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
New Net Users
New Users

Software
Digital Music
Gaming World

Home Security
Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Handhelds / PDAs
Displays / Monitors
Components
Networking Hardware

Peripherals
Laptops/Notebooks
Storage
Servers

Desktops
New Users
Misc
Apple

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMWare
Misc
Web Development

OS
CYGWIN
Voice Recognition
Message Queue
Quality Assurance
Security
Firewalls
MultiMedia Applications

Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals

Devices
Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
WebApplications
IDS
Vulnerabilities
Email Clients

File Sharing
Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMWare

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel

Algorithms
Game
Signal Processing
Project Management
Open Source

Database
Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Images

Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration
WebApplications

Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Broadband

Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Community Advisor
Lounge
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles

Community Support

Suggestions
New to EE
New Topics
Community Advisor

CleanUp
Announcements
General

Feedback
Input
EE Bugs

09.21.2007 at 04:15PM PDT, ID: 19939794

Rank: Guru

SBennett:

Make sure that in your code that indexes the content, that it does not use any spaces in the category field. If there is a space then that will cause problems.

09.21.2007 at 04:20PM PDT, ID: 19939806

Rank: Guru

SBennett:

for example if in your cfindex you enter
<cfindex category="cat1, cat2, cat3"...

then that will put the document in categories of 'cat1' and ' cat2' and ' cat3'

it needs to be like:
<cfindex category="cat1,cat2,cat3"...

09.24.2007 at 08:18AM PDT, ID: 19949042

krugar77:

No that isn't the issue. My code is the following:
<cfindex
query="get_cssi_meetings"
collection="meetings_data"
action="Refresh"
type="Custom"
key="cssi_key"
title="cssi_name"
body="cssi_name"
custom1 = "cssi_name"
custom2 = "cssi_link"
category ="boston">

As I stated I can do a dump on the collection and see the proper records and can see that boston is listed as the category.

However, when I do s CFSEARCH and specify a category I get no results. When I do the same search and remove the category I get results. Even though the collection has categories enabled and a dump of the collection verifies the data.

09.24.2007 at 11:21AM PDT, ID: 19950422

Rank: Guru

SBennett:

Have you read through this article yet?
http://www.adobe.com/devnet/coldfusion/articles/search_cf7_04.html

From the way you are describing it it sounds like you are doing eveything correctly, The only thing I can think of is maybe it doesn't work well with custom collections, perhaps the category/categorytree functionality only works with file/path colections or something. I've used categories with file collections but never a custom one...I am going to test to see If I can get it to work a little later today and I'll get back to you.

09.24.2007 at 12:47PM PDT, ID: 19951191

krugar77:

Thank you for the follow up SBennett. Any follow-up would be appreicated as I sadly don't have the time today to test it on a file collection to see if there is any difference.

I did check with:
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000278.htm

and I did not notice any restriction for using categories on differing types. I am as bewildered as you are. One would think the collection and index would not work if that was the case. Sadly it isn't. I'll play around some more and see what I can find too.

09.25.2007 at 08:31AM PDT, ID: 19956558

krugar77:

Well I've done more digging. I don't know what the problem is but it now works. I deleted and recreated the collection in the CFADMIN. That didn't work. So I deleted the collection in CFADMIN, restarted CF and manually using tags and not the CFADMIN created the collection. That works. Odd. Very odd.

09.25.2007 at 09:34AM PDT, ID: 19957025

Rank: Guru

SBennett:

hmmm that is strange... perhaps there is a bug in cfadmin. what version of cf are you runing on?

09.28.2007 at 02:30PM PDT, ID: 19981912

krugar77:

7.02 I believe

11.22.2007 at 09:20AM PST, ID: 20335459

jeninbrighton:

This happened to me too, and I couldn't find much in the way of help or documentation about Verity (other than the basics). What seemed to work in the end, was not only deleting the collection, but actually deleting and renaming it. My theory is that it has something to do with creating a query without categories, then deleting it and re-creating it WITH categories. It goes a bit wonky. Hope this helps!

Accepted Solution

03.13.2008 at 02:40PM PDT, ID: 21121155

krugar77:

delete and restart seemed to work.

03.13.2008 at 04:02PM PDT, ID: 21121655

Rank: Guru

SBennett:

It seems to me that jeninbrighton should get the points.

03.14.2008 at 05:44AM PDT, ID: 21124881

krugar77:

How does it work if I did what someone suggested before they suggested and forgot to check the post until now? Can I assign partial points?

Also as a side note I only had to delete not delete and rename as was suggested. The deletion however did not work as a fix until CF was restarted which was not suggested. Can't explain it but that's what it took to work.

03.14.2008 at 07:52AM PDT, ID: 21126068

Rank: Guru

SBennett:

General rules of thumb for point giving:

If an expert posts the correct answer, you should award them the points with a grade of "A".

If an expert gives most of an answer but maybe you had to figure alittle bit out for your self then give them the points with a "B"

If an expert gives you a little bit of information that leads you to the correct answer, but requires you to do a lot of research your self, then give them the points with a "C".

If no one helps you get the answer in any way, or you figure out the answer and are the first one to post a comment with the answer, then you can close the question and get your points refunded.

In this case jeninbrighton posted the correct answer before you did, so it would be courteous for you to give them the points even though you may have already figured it out on your own but forgot to wrap this question up when you figured it out.

03.14.2008 at 08:00AM PDT, ID: 21126136

krugar77:

Easy enough. Thanks for the advice.

20080236-EE-VQP-29 / EE_QW_1_20070628