null in cfqueryparam

[newcf]

in sql stamement i have where name is null, how do i put it in the cfqueryparam

where name = <cfqueryparam type="cf_sql_char" value ="" is NUll />?

thanks

[-__cfSearching__-]

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

[newcf]

thanks,

so if i am passing specify value not the variables from the form then i don't need the cfqueryparam right?

example,

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">?

thanks again

[Owainnorth]

That is correct. CFQueryparam is for variables, so if it's not going to change it doesn't need one.

[newcf]

thanks all