Search results for query: *

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 =...

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?

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...

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...

Ok great you allready did the job, Greets Marco

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...

Hi 8ball, Try this: http://forum.java.sun.com/thread.jspa?forumID=54&messageID=990447&threadID=262598

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...

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>...

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#

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...

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...

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...