I thought you could do the below to pass a null value if the user didn't
enter anything into the form field (it's an optional field, for example)
fax = <cfqueryparam
value="#FORM.fax#"
cfsqltype="CF_SQL_VARCHAR"
null = "#YesNoFormat(NOT Len(Trim(Form.fax)))#" />
I get a form.fax undefined error.
I thought I had my quota of coffee today. Maybe not....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:256034
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
