You need to wrap it in a function.
Pascal
> -----Original Message-----
> From: Tim Blair [mailto:[EMAIL PROTECTED]
> Sent: 24 September 2004 15:23
> To: CF-Talk
> Subject: [Spam?] RE: datetime problems - 01/01/1900
>
> Just a point to note:
>
> <cfqueryparam ... null="#YesNoFormat(NOT Len(myvar))#">
>
> You don't actually need the yesnoformat() function call in there --
the
> null="" field takes a boolean value; a numeric value can be treated as
a
> boolean (any non-zero value is TRUE), and len() returns a numeric
value,
> so you can just use:
>
> <cfqueryparam ... null="#NOT len(myvar)#">
>
> Maybe it's just me being picky... :)
>
> Tim.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
