-
1. Re: Fail to pass datetime value to store procedure
Dan Bracuk Apr 26, 2012 2:59 AM (in response to Phinehas1234)Your cf code looks ok. What does the stored proc look like?
-
2. Re: Fail to pass datetime value to store procedure
BKBK Apr 26, 2012 3:19 AM (in response to Phinehas1234)Shouldn't the year be 4 digits instead of 2, that is, yyyy? In any case, you should validate the input values. (Update: The following example is a simple validation routine. You could make yours as sophisticated as you want.)
<!--- Validate form field values yy, mm and dd before passing them to stored procedure --->
<cfif IsDefined("form.yy") and isNumeric(form.yy & form.mm & form.dd) and isDate(form.mm & "/" & form.dd & "/" & form.yy)>
<cfprocparam cfsqltype="CF_SQL_TIMESTAMP" value="#CreateDate(form.yy, form.mm, form.dd)#">
<cfelse>
<cfprocparam cfsqltype="CF_SQL_TIMESTAMP" null="yes">
</cfif>
-
3. Re: Fail to pass datetime value to store procedure
Phinehas1234 Apr 26, 2012 7:03 PM (in response to Dan Bracuk)Finally, I find that I can pass the parameter correctly. The problem is the dynamic sql in store procedure and already solved using CONVERT and CAST function. Thanks.
-
4. Re: Fail to pass datetime value to store procedure
BKBK Apr 27, 2012 12:45 AM (in response to Phinehas1234)Fine. Please kindly mark the question as answered.

