<cfset qDave = queryNew("mystring")>
<cfset queryAddRow(qDave)>
<cfset querySetCell(qDave,"mystring","This is Dave's test.")>
<cfset sSearchString = "This is Dave's test.">
<cfdump var="#qDave#">
<cfquery dbtype="query" name="q">SELECT * FROM qDave WHERE mystring =
'#sSearchString#'</cfquery>
<cfdump var="#q#">
Your example code above worked perfectly for me.
I notice that you did not have preserveSingleQuotes() in this example and you
should not. This is the use case where you want the single quotes escaped -
which is what CF does by default and preserveSingeQuotes() is designed to
reverse when that use case is required.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
---------
| 1 | |
--------- Binary Sudoku
| | |
---------
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270383
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
