Under normal circumstances I would do this but I consider it to be bad practice and would only use it as a last resort. The reason for this is that occasionally there can be errors if the field=null is not the last variable in the list passed to the stored procedure. Thanks for the input anyway. ________________________________
From: Anthony Prato [mailto:[EMAIL PROTECTED] Sent: Fri 15/07/2005 16:52 To: CF-Talk Subject: Re: Coldfusion7, <cfprocparam> & blank date fields! If I understand correctly you are trying to have these date parameters of your stored procedure optional. Why not make them optional in the stored procedure? In your stored procedure when you define for example "@DOB datetime," Just change it to "@DOB datetime=null" This will set the parameter @DOB to null if it is not passed into the SP. (this is for SQL server, that is what you are using correct?) Anthony ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212061 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
