regardless of what the value attribute says. For instance, if you have a
select box with a blank first option and the actual options have a numeric
value, you might use a CFQUERYPARAM like this:
<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.
Cheers,
barneyb
> -----Original Message-----
> From: Jamie Jackson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 19, 2004 11:36 AM
> To: CF-Talk
> Subject: <cfqueryparam> question ("null" attribute)
>
> I'm not quite sure how the null attribute works in <cfqueryparam>
>
> ===========================
> From the docs:
> null [Optional] [Default="No"]
> Description: Whether parameter is passed as a null value.
> *Yes: tag ignores the value attribute
> *No
> ===========================
>
> Can anyone give me an example of the "null" attribute put to good use?
>
> Thanks,
> Jamie
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
