><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]

Reply via email to