Whoops. My bad. :P Replace: #IsDate(request.start_date)#
With: #YesNoFormat(NOT IsDate(request.start_date))# Do the same thing for the end_date too. I was too hasty with my post. Again, my apologies. :) ---------------------------- James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -----Original Message----- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 7:30 AM To: CF-Talk Subject: RE: StoreProc Driver question ---------- Original Message ---------------------------------- From: "James Ang" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 13 Jan 2003 17:54:15 -0800 ><cfprocparam type="InOut" > cfsqltype="CF_SQL_TIMESTAMP" > dbvarname="start_date" > variable="start_date" > value="#request.start_date#" > null="#IsDate(request.start_date)#"> If Request.start_date is a date, wouldn't this code pass a NULL instead? Don't you want to pass a null if it's NOT a date? -------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
