the error looks like it's trying to tie 2 pieces of data together with a compare ie x>=y and x="24" and y="24 null".. try looking at the data and see if you find anything funky like that. if the stored proc itself is throwing a db error you'll have a better chance of more info and a being able to google a resolution for the real symptom.
----Original Message Follows---- From: Ryan Everhart <[EMAIL PROTECTED]> Reply-To: [email protected] To: [email protected] Subject: Strange CF Error Date: Thu, 3 Mar 2005 13:38:27 -0600
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
----------------------------------------------------------
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
