nah. leave it as an empty string
and then
<cfqueryparam
cfsqltype="CF_SQL_DATE"
value="#args.dateField#"
null="#YesNoFormat(not len(args.dateField)#"
/>
my 2c
barry.b
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Adam
> Chapman
> Sent: Wednesday, 6 July 2005 3:57 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] RE: cfparam for date
>
>
> Hi Tom,
>
> Howzabout this..
>
> <cfparam name="session.myevent.rsvpby" default="" />
>
> UDPATE thisTable
> SET thisDate =
> <cfif not isDate(session.myevent.rsvpby)>
> -- or however you insert your dates..
> #createODBCDate(session.myevent.rsvpby)#
> </cfelse>
> NULL
> </cfif>
> WHERE this = that
>
> Cheers,
> Adam
>
> -----Original Message-----
> From: Tom MacKean [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 6 July 2005 3:37 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] cfparam for date
>
>
> If users don't enter a date in a field, I want it to go into the
> database as null.
>
> However,
>
> <cfparam name="session.myevent.rsvpby" default="" type="date">
>
> and
>
> <cfparam name="session.myevent.rsvpby" default="null" type="date">
>
> don't work.
>
> What do I use for a default value of nothing when it's a date?
>
> Thanks,
>
> Tom MacKean
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
