Solved

ColdFusion Verity search...

Posted on 2011-03-25
1
430 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
1 Comment
 
LVL 25

Accepted Solution

by:
dgrafx earned 500 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Today, I was working on some optimization and spam-stopping techniques when I encountered Ben Nadel's post to reduce spam feature using Math (http://www.bennadel.com/blog/197-How-I-Stop-Spammers-On-My-ColdFusion-Blog.htm). While this method is not o…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now