Hi, In the past, I have used the following (or something close to it) to pass a NULL value via cfqueryparam
<cfqueryparam cfsqltype="cf_sql_numeric" value="#session.myevent.rsvpby#" null="#IIF(session.myevent.rsvpby eq "", yes, no)#"> oohh, hang on....... this method does not work for dates? >>> [EMAIL PROTECTED] 07/07/05 10:36 am >>> Thank you all for your responses. I used an if statement in my sql and everything now works beautifully. No one answered my original question. Am I to conclude that there is no way to use cfparam to set a date to null? Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 6 July 2005 4:03 PM To: CFAussie Mailing List Subject: [cfaussie] Re: cfparam for date On Wed, Jul 06, 2005 at 03:36:54PM +1000, Tom MacKean wrote: > 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? <cfqueryparam value="#DateFieldVar#" CFSqlType="CF_SQL_TimeStamp" null="Yes"> You can go to the added step of making the null="Yes|No" into a function such as null="#isNullDate(DateFieldVar)#" which returns Yes or No dyamically. It's also a good place to trap user errors that the interface might have missed, such as entering "Tuesday" in a DD/MM/YYYY field. Cheers Paul Haddon Technical Services Manager Formstar Print Technologies --- 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/ NOTICE: Medical and scientific information provided in print and electronically by Sydney IVF might not be relevant to your own circumstances and should always be discussed with your own doctor before you act on it. This communication is confidential and may contain copyright or otherwise protected information of Sydney IVF Limited or a third party. If you are not the intended recipient of this communication please immediately let us know by reply email or telephone us on +61 2 9221 5964, delete the communication and destroy all copies. --- 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/
