Could you have some special value represent null?
<cfqueryparam name="foo" value="#foo.value()#" null="#foo.value() eq 0#"/>

Could you have a separate function to check if the value is null?
<cfqueryparam name="foo" value="#foo.value()#" null="#foo.isNull()#"/>

Patrick

On 9/16/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I agree, but nulls are valid options in the database.  I like the
> ability to restrict the return type of a function and think altering
> that to string or any to accommodate nulls is a step backwards and could
> have negative consequences.


-- 
Patrick McElhaney
704.560.9117
http://pmcelhaney.weblogs.us


----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to 
[email protected] with the words 'unsubscribe cfcdev' as the subject of the 
email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting 
(www.cfxhosting.com).

CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm

An archive of the CFCDev list is available at 
www.mail-archive.com/[email protected]


Reply via email to