NULL attribute of CFQUERYPARAM

i'm not sure if i'm using null attribute of cfqueryparam correctly.

i know need records status null. in db column set allow null

 

so can this:

 

<cfquery name="aa" datasource="#application.dsn#>

select column1, column2

from mytable

where status null

</cfquery>

 

when using cfqueryparam, can way:

 

<cfquery name="aa" datasource="#application.dsn#>

select column1, column2

from mytable

where status = <cfqueryparam cfsqltype="cf_sql_varchar" value=" " null="yes">

</cfquery>

 

please advice

yes, believe should work.  according documentation if have null attribute set "yes" ignores value attribute.

 

is not working?  error get?

More discussions in ColdFusion

adobe