ColdFusion Verity search...

Posted on 2011-03-25
Medium Priority
Last Modified: 2012-05-11
I'm creating a search for my website, and I have a question... I was able to create a collection,  and I'm able to search it.

But here is the problem... I can only search using the primary key, how can I make all columns in the database searchable?

Here is the code I have for indexing and for search...

<cfindex collection="orthopedicsurgeon" action="update" type="custom" query="qryGetdoc" 
	     body="ProviderNPI, ProviderLastName, ProviderFirstName, ProviderMiddleName, ProviderBusinessPracticeAddress, ProviderBusinessPracticeAddress2,ProviderBusinessPracticeCity, ProviderBusinessPracticeState, ProviderBusinessPracticePostalCode, PracticeAbout"
         key="ProviderNPI" language="english">

<!----- SEARCH ---->
<cfsearch name="search" collection="orthopedicsurgeon" type="simple" criteria="#q#">

<cfdump var="#search#">

Open in new window

Question by:Medrise
1 Comment
LVL 25

Accepted Solution

dgrafx earned 2000 total points
ID: 35221990
ok - this will be condensed - I just posted and my wireless connection dropped and all was lost ...
so anyway

not sure what you mean by "I can only earch by primary key"
what do you really mean? cause that doesn't make sense - might want to reword that

but to answer what i think you might mean
<cfsearch name="search" collection="orthopedicsurgeon" type="simple" criteria="#q#">
<cfif listlen(valuelist(search.key))>
<cfquery ...>
select ...
where ProviderNPI IN (valuelist(search.key))
then just do an output of the query

good luck ...

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question