All, My users are getting a strange error when they hit one of my CF pages. The error, shown below, shows up every now and then and then goes away, for no reason. The page that page that they are hitting is pretty simple and the error points to line 51 which is a stored proc. I'll include the code calling the stored proc. Error The Diagnostics of the error : 24 >= 24 null The error occurred on line 51.
<!--- sp to get referrals ---> <cfstoredproc procedure="usp_TE_getBOReferrals_v2" datasource="CBS"> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="SearchType" value="#url.SearchType#" null="No"> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="SearchFor" value="#usearchfor#" null="No"> <cfprocresult name="getreferrals"> </cfstoredproc> Line 51 is actually the second to last line in this code the cfprocresult. Another thing that is confussing about with this error is that it only shows up on my production server. If I hit the same page on me development box I get no error. Both the production and developement web server hit the same SQL box. I really don't understand the 24>=24 null description. Any help would be appreciated. Thanks, Ryan PS since I've been righting this email the error message has gone away again. ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
