cfqueryparam messin up query

[albatross07]

I have an access database that contain a linked table which is an view within
Oracle the connection works fine. when I query the View/table and use a char
datatype against a char filed and use cfqueryparam i get no rows back.

If I take out the cfqueryparam it works fine. I have confirmed that I have the
correct datatypes:

THIS WORKS:
SELECT
[LAWSON_SHC_EMPLOYEE_V].[LAST_NAME]
FROM
LAWSON_SHC_EMPLOYEE_V
WHERE
LAWSON_SHC_EMPLOYEE_V.LAST_NAME= '#form.Lname#'
THIS DOESN'T WORK:

SELECT
[LAWSON_SHC_EMPLOYEE_V].[LAST_NAME]
FROM
LAWSON_SHC_EMPLOYEE_V
WHERE
LAWSON_SHC_EMPLOYEE_V.LAST_NAME= <cfqueryparam value="#ucase(form.Lname)#"
cfsqltype="cf_sql_char">

we have policy of using cfqueryparam here at work and I need to explain to my
boss why this doesnt work it and it is started to get uncomfortable. any help
would be appreciated

Thank You

Ron

[Adam Cameron]

> LAWSON_SHC_EMPLOYEE_V.LAST_NAME= '#form.Lname#'

> LAWSON_SHC_EMPLOYEE_V.LAST_NAME= <cfqueryparam value="#ucase(form.Lname)#"
> cfsqltype="cf_sql_char">

You're not filtering on the same criterion. Could that have something to
do with it?

--

Adam