I think, but did not test, that if you use the LIKE directive, it will
be case-insensitive.
SELECT
*
FROM
[table]
WHERE
[column] LIKE <cfquaryparam value="ben" />
However, be aware that the LIKE might create other issues like using the
"_" as a wild card match, and % and what not.
Other than that, Dave Watts knows way more than I do.
......................
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-----Original Message-----
From: Joy Holman [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 10:42 AM
To: CF-Talk
Subject: CF string case must match SQL field value case
I have some SQL select queries that act case-insensitive and others that
only return values that match the string case between the CF string
variable and the SQL field value requested.
I can address it by setting the CF value with "Ucase" and the SQL value
with "UPPER", but I don't think it should be necessary since I have
other queries that return case-insensitive results without making case
conversions.
Any ideas on what's causing only case matches to be returned from a
SELECT query?
Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267634
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
