cf-talk,
I'm _Sorry_ for my poor English.
Simple code:
<cfset sql_search_string="'%"&#replace(form.keywords, " ", "%','%","ALL")#&"%'">
<cfquery datasource="#application.dsn_name#" name="results">
SELECT iArticleID, dtFileDate
FROM Article
WHERE vchTitle LIKE (#PreserveSingleQuotes(sql_search_string)#)
OR vchKeywords LIKE (#PreserveSingleQuotes(sql_search_string)#)
OR txBody LIKE (#PreserveSingleQuotes(sql_search_string)#)
OR vchDesc LIKE (#PreserveSingleQuotes(sql_search_string)#)
ORDER BY dtFileDate DESC
</cfquery>
Database contain string <
President Clinton's Presidency has been a failure
in the one area that really matters: foreign policy. >
I enter word < President > in search form and #results.recordcount#
give me 0.
Or string < Bill Clinton USA > (keyword < Clinton >) with the same results.
vchTitle, vchKeywords, vchDesc - field type 'Text'
txBody - field type 'Memo'
Database - MS Access '97
Question: what is wrong? Last 16 hours didn't give my sense of
relief.
--
Regards,
Alex mailto:[EMAIL PROTECTED]
Certified HTML Programmer,
Java Script Programmer and
High IT Aptitude Specialist.
http://www.brainbench.com/transcript.jsp?pid=145368
Certified Cold Fusion 4.1 Programmer.
http://www.ecertifications.com/
Permanent FAQ Team player.
http://faq.worldrecovery.com/
Permanent MTeam player.
http://members.tripod.com/mteam1/
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.