> 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?
This is generally determined by the collation of the specific database in question. If you're using a case-sensitive collation, you must treat your comparisons as case-sensitive. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
