Well, it's not actually sending to a database in this particular query; it's querying a previous query. But yes, the CF function will process before making the query request, thereby converting the form var to lower case. Then by using the SQL lower() function on the column that you're querying, it also will be in lower case.
On 2/11/07, Bob Imperial <[EMAIL PROTECTED]> wrote: > > Ahhh.... so am I understanding this correctly, it converts it to lower > case > before it actually sends the request to the db? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:269451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
