---------- 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4