Deanna Schneider wrote:
> You should change your fields in the database to allow for nulls. Then, on
> the form action page, make sure you check for the existing of the variable,
> and if it's blank, set it to null. CF doesn't actually handle nulls. Instead
> it converts them to empty strings.
>
> Soooo,
>
> <cfparam name="mydate" default="null">
> <cfif isdefined("mydate") and mydate is "">
> <cfset mydate = "null">
> </cfif>
Thanks. It turns out that SQL server does accept NULLS, but I didn't
know that CF doesn't handle them.
>
> Note also that if you're doing any calculations that include the null
> integer fields, that you'll want to convert them in the database. I'm not
> sure what the SQL Server syntax for that is, but in oracle it's
> SELECT nvl(mynullinteger, 0) AS mynotnullinteger <---this changes it to zero
>
> -d
>
>
> Deanna Schneider
> Interactive Media Developer
> [EMAIL PROTECTED]
>
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
