-----Original Message-----
From: Jamie Jackson [mailto:[EMAIL PROTECTED]
Sent: Friday, 20 February 2004 8:14 a.m.
To: CF-Talk
Subject: Re: <cfqueryparam> question ("null" attribute)
><cfqueryparam type="cf_sql_integer" value="#form.myVar#" isNull="#NOT
>isNumeric(form.myVar)#" />
>
>That will insert the value provided, unless it's not numeric, in which case
>it'll insert NULL.
Thanks Barney,
One small correction though: I don't think CF can evaluate:
#NOT isNumeric(form.myVar)#
It seems you have to wrap "NOT {_expression_}" with a function, like:
#yesNoFormat(NOT isNumeric(form.myVar))#
Thanks,
Jamie
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
