?
Solved

ColdFusion Verity search...

Posted on 2011-03-25
1
Medium Priority
?
435 Views
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

0
Comment
Question by:Medrise
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 25

Accepted Solution

by:
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))
</cfquery>
then just do an output of the query
</cfif>

good luck ...
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The technique is by far very Simple! How we can export the ColdFusion query results to DOC file?  Well before writing this I researched a lot in Internet but did not found a good Answer anyways!  So i thought now i should share my small snippet w…
I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month9 days, 6 hours left to enroll

764 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