FWIW, having the case for "key" works on both MySQL & Oracle.
As an associated enhancement, how about using: WHERE lower(label) like <cfqueryparam cfsqltype="cf_sql_varchar" value="%#lCase(form.searchTypename)#%" /> As the search terms. I.e., case independent. Tomek -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
