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 derfloh 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)
Hi Mike, This is my query 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... <cfoutput query="art"> <cfset MessageComments =... -
Get both words: word Word (ignore capitalize)
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? -
How to Highlight a matched word ?
Ok i've got it, once again thinking way to complex :p In the beginning i told that it was working but that only the first record of the column with the match words went highlighted, that was with this line: <cfset MessageComments = "#Replace(MessageComments, '#zok.titel#', '<a... -
How to Highlight a matched word ?
Ok maybe it's getting more complicated then it is, All i want to know is this: Select everything from onderwerpen where titel has a match with anything from the #artikel.tekst# (large text) output, what's the code for that? I tried the below code at first, but ofcourse like this i never have... -
How to Highlight a matched word ?
Hi it's hard for me to explain it correctly sorry for that, In coldfusion i want to format artikel.tekst from the query artikel. <cfset MessageComments = "#Replace(MessageComments, '#zok.titel#', '<a href="index.cfm?id=#zok.id#&spot=#zok.echtenaam#" title="Bekijk en/of bewerk de definitie van... -
server wont start
Hi 8ball, Try this: http://forum.java.sun.com/thread.jspa?forumID=54&messageID=990447&threadID=262598 -
CFMAIL
Hi DerAdi, I think this is indeed a mail server setting issue, if you use the right smtp settings in the cfmail... I think you just have to ask the provider to give the right permissions and settings. I also had this problem with not retrieving email while the setting where all good, one time... -
How to Highlight a matched word ?
Hi again, thanx for helping me out here... So table artikel displays the text and with table zok i want to match words that are in column titel of zok and in column tekst of table artikel <cfquery name="artikel" datasource="spirilog"> SELECT * FROM onderwerpen WHERE Id = #URL.Id# </cfquery>... -
How to Highlight a matched word ?
Hi r937, Is that for access ? I get all sort of errors... What to do with table.theword ? Can i replace sun_web_ghost for #artikel.tekst# -
Displaying many records within CFMail
Hi 3dcolor, I have a example for you included: <cfparam name="PageNum_recent" default="1"> <cfquery name="recent" datasource="spirilog"> SELECT * FROM onderwerpen WHERE datum = '#DateFormat(Now())#' ORDER BY id DESC </cfquery> <cfquery name="emailadressen" datasource="spirilog"> SELECT... -
How to Highlight a matched word ?
Hi guys, thanx for your help. I'm using access (yeah i know) right now, sorry i didn't told that, quite important huh? I tried the code of falconseye but stil only get the first value (sun) to match in the text. I tried to replace sun,ghost with #artikel.tekst# (the value of the text where the... -
How to Highlight a matched word ?
Hi guys, I want to highlight any word in my text that matches a word that is in a database table. So if in the table words are: sun / web / ghost then i want in the text these words highlighted. Now only the top record is matching so in this example sun. How can i change the code so that any...
