Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get both words: word Word (ignore capitalize)

Status
Not open for further replies.

marcovdo

Programmer
Feb 1, 2006
13
NL
When i do a search for words how do i make sure that both words like; word Word , whil show up, so capitalized or not?

Is there i basic method for that?
 
Where do you want to search? In a Database, if so which DB or in a string or a list??

There are multiple functions that can produce this kind of functionality, but it depends on where you want to search.

My blog:
 
Hi Mike,

This is my query code:

Code:
<cfquery name="art" datasource="spirilog">
SELECT * FROM onderwerpen where echtenaam = 'spot' ORDER BY Id DESC
</cfquery>

This is the code in the body to filter and replace where matched...

Code:
<cfoutput query="art">
	<cfset MessageComments = "#Replace(MessageComments, '#art.titel#', '<a href="index.cfm?id=#art.id#&spot=#art.echtenaam#" title="Bekijk en/of bewerk de definitie van #art.titel#..."><span class="style3">#art.titel#</span></a>', 'ALL')#">
	</cfoutput>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top