select *
from qQ2
where
lower(column_1) = '#LCase(cF1)#'
Monday, September 17, 2007
Query Of Queries is case sensitive
I discover recently that Query of queries is case sensitive. to solve the problem i use the function Lcase to convert the coldfusion variables to low case and the query function Lower to convert the query column to low case.
select *
from qQ2
where
lower(column_1) = '#LCase(cF1)#'
select *
from qQ2
where
lower(column_1) = '#LCase(cF1)#'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment