Try:
vchTitle LIKE '%#PreserveSingleQuotes(sql_search_string)#%'
Russel Madere, Jr.
Web Developer
"Be good and you will be lonesome.
Be lonesome and you will be free.
Live a lie and you will live to regret it."
Jimmy Buffett
That's What Living Is To Me
-----Original Message-----
From: Alex Puriche [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 9:47 AM
To: [EMAIL PROTECTED]
Subject: SQL.LIKE question
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.
------------------------------------------------------------------------------
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.
