Do you mean you wish to find records where the name is NULL? If so, you do not need to use cfqueryparam. Just use the keywords IS NULL:
WHERE Name IS NULL
so if i am passing specify value not the variables from the form then i don't need the cfqueryparam right?
in sql statement i have: where work='p' then i don't think i need to put in in the cfqueryparam like
<Cfqueryparam type="sql_char" value ="p">?
1 person found this helpful
That is correct. CFQueryparam is for variables, so if it's not going to change it doesn't need one.