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/
