Jake Churchill wrote:
> Did you dump form to make sure fax is there?
Let's make it more difficult. It may or may NOT exist in the given
application.
I'd like to avoid the CFIF structure if possible:
fax=
<cfif IsDefined("FORM.fax") AND #FORM.fax# NEQ "">
<cfqueryparam
value="#FORM.fax#"
cfsqltype="CF_SQL_VARCHAR" >
<cfelse>
NULL
</cfif>
So, it looks like the below should have me covered, right?:
fax = <cfqueryparam
value="#FORM.fax#"
cfsqltype="CF_SQL_VARCHAR"
null = "YesNoFormat(NOT (StruckKeyExists(form,'fax'))" >
....but this gives me:
The value of the attribute NULL is invalid.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256038
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
