>> null="#iif(COURSE.COU_LANGUAGE_STUDY IS '',de('Yes'),de('No'))#"
>
>Why not #yesNoFormat(COURSE.COU_LANGUAGE_STUDY IS '')# ?
The code we're using is:
null="#yesNoFormat(NOT Len(trim(CFQUERYPARAM VALUE IN HERE)))#"
It looks like my bosses previous suggestion doesn't work if you have any
spaces. This one at least covers that and also checks to see if its empty!
Also to cover the large number of changes we're having to make we've come up
with a regular expression which passes through a directory of files, looks for
cfqueryparam's which either don't have a null attribute already or aren't of
type VARCHAR and inserts this code.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274177
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
